/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 vote371 views1 answer
Set assembly highligh vim
Assembly
0 vote378 views1 answer
Sort in assembly pcspim
Assembly
2 votes492 views1 answer
Func assembly
Assembly
112 votes423 views10 answers
Visual studio code
Assembly
1 vote483 views1 answer
Google sheets conditional formatting custom formula current cell
Assembly
0 vote422 views1 answer
Pyplot name axes
Assembly
0 vote407 views1 answer
Error: failed to synchronize all the database archlinux
Assembly
1 vote404 views1 answer
Latex reference labels
Assembly
0 vote333 views1 answer
Change terminal font color
Assembly
1 vote412 views1 answer
Pickle write in directory
Assembly