/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 vote400 views1 answer
Generate random strings only with uppercase letters and digits in Python
Assembly
2 votes475 views2 answers
Google docs if empty
Assembly
0 vote385 views1 answer
Google apps script format date string
Assembly
1 vote475 views1 answer
Custom color bootstrap buttonm
Assembly
0 vote431 views1 answer
That long word from mary poppins
Assembly
0 vote384 views1 answer
Nano error reading lock file not enough data read
Assembly
0 vote396 views1 answer
Html drag and drop anywhere
Assembly
112 votes443 views10 answers
Visual studio code
Assembly
0 vote401 views1 answer
How to check if chat is nsfw discord.py
Assembly
13 votes493 views6 answers
Flutter button border radius
Assembly