/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 vote353 views1 answer
Android studio manually add copyright
Assembly
0 vote329 views1 answer
Docker cannot stop container
Assembly
0 vote398 views1 answer
Cout boolalpha
Assembly
2 votes436 views1 answer
Array month name
Assembly
0 vote345 views1 answer
Resize pdf file
Assembly
1 vote414 views1 answer
Json vulnerabilities
Assembly
0 vote412 views1 answer
Multiply two numbers assembly lmc
Assembly
-1 vote350 views1 answer
Assembly print
Assembly
0 vote403 views2 answers
Datauristring pdf open in php
Assembly
0 vote351 views1 answer
Open new terminal window mac
Assembly