/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

-1 vote124 views1 answer
Google appscripts cell get background color
Assembly
0 vote121 views1 answer
Vba concatenate strings and integer
Assembly
0 vote77 views1 answer
Change terminal font color
Assembly
0 vote157 views1 answer
Discord.py change status to invisible
Assembly
0 vote120 views1 answer
Sort in assembly pcspim
Assembly
0 vote123 views1 answer
Scanf prototype in c
Assembly
1 vote151 views1 answer
Google sheets check if empty
Assembly
0 vote125 views1 answer
Install retroarch on Linux
Assembly
0 vote138 views1 answer
Discord bot name of person being tagged
Assembly
0 vote119 views1 answer
Socket failed: EPERM (Operation not permitted)
Assembly