/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 vote406 views1 answer
Vba check if object exists
Assembly
0 vote397 views1 answer
Assembly language loop example masm
Assembly
1 vote509 views1 answer
Sqlalchemy filter date today
Assembly
1 vote491 views1 answer
Custom color bootstrap buttonm
Assembly
0 vote408 views1 answer
Cron job when not enough time
Assembly
0 vote415 views1 answer
Cron job when out of time
Assembly
13 votes504 views6 answers
Flutter button border radius
Assembly
0 vote397 views1 answer
Resize pdf file
Assembly
0 vote414 views1 answer
Post a gif in github
Assembly
0 vote469 views1 answer
Cannot open self /usr/local/bin/docker-compose
Assembly