/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 vote191 views1 answer
Iterate over tqdm range
Assembly
2 votes396 views2 answers
Google docs if empty
Assembly
0 vote205 views1 answer
2su.communications.syr.edu]2su.communications.syr.edu
Assembly
0 vote214 views2 answers
Chrome version command line
Assembly
0 vote197 views1 answer
Nano error reading lock file not enough data read
Assembly
0 vote191 views1 answer
ARM assembly divide by 2
Assembly
0 vote196 views1 answer
Assembly language loop example masm
Assembly
-1 vote201 views1 answer
Assembly print
Assembly
0 vote201 views1 answer
Sparsefile
Assembly
112 votes390 views10 answers
Visual studio code
Assembly