/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 vote137 views1 answer
Visual studio change assembly name
Assembly
0 vote129 views1 answer
Vba and
Assembly
0 vote127 views1 answer
Windows detect system dark mode
Assembly
0 vote127 views1 answer
Node js vulnerabilities
Assembly
1 vote91 views1 answer
Restart kde
Assembly
2 votes216 views1 answer
Cancel shutdown timer
Assembly
0 vote132 views1 answer
Assembly fibonacci
Assembly
0 vote126 views1 answer
Install retroarch on Linux
Assembly
1 vote198 views1 answer
Sqlalchemy filter date today
Assembly
0 vote126 views1 answer
Include code in latex
Assembly