/Assembly/Vba check if shape name exists

Vba check if shape name exists

Function shapeExists(shapeName As String) As Boolean
'returns TRUE if a shape named [ShapeName] exists on the active worksheet
    Dim sh As Shape
    For Each sh In ActiveSheet.Shapes
         If sh.Name = shapeName Then shapeExists = True
    Next sh
End Function

'Example Usage
If Not shapeExists("My Shape Name") Then MsgBox "Shape not found!"

Source: stackoverflow.com

Similar codes

0 vote222 views1 answer
Pycryptodome aes 256 cbc
Assembly
0 vote204 views1 answer
Set assembly highligh vim
Assembly
0 vote195 views1 answer
How to listen for changes on an ObservableMap
Assembly
2 votes413 views1 answer
Cancel shutdown timer
Assembly
0 vote215 views1 answer
Vba hello world
Assembly
1 vote404 views1 answer
Google sheets conditional formatting custom formula current cell
Assembly
0 vote197 views1 answer
Socket failed: EPERM (Operation not permitted)
Assembly
1 vote405 views1 answer
Jupyter list notebooks
Assembly
2 votes402 views1 answer
Array month name
Assembly
0 vote218 views2 answers
Convert html to text
Assembly