/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 vote176 views1 answer
Sort in assembly pcspim
Assembly
0 vote194 views1 answer
Spliting dateetimeindedx into date and time column
Assembly
0 vote179 views1 answer
Cron job when not enough time
Assembly
1 vote369 views1 answer
Sqlalchemy filter date today
Assembly
1 vote376 views1 answer
Google sheets check if empty
Assembly
0 vote172 views1 answer
Resize pdf file
Assembly
0 vote200 views1 answer
Jz contion assembly
Assembly
2 votes391 views2 answers
Press button on enter
Assembly
3 votes357 views1 answer
Using shape property in flutter for circular corner
Assembly
0 vote182 views1 answer
Android studio manually add copyright
Assembly