/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 vote201 views1 answer
Node js vulnerabilities
Assembly
112 votes409 views10 answers
Visual studio code
Assembly
0 vote207 views1 answer
Cron job when out of time
Assembly
0 vote215 views1 answer
Assign value to struct variable
Assembly
0 vote205 views1 answer
Vba and
Assembly
0 vote202 views1 answer
Bidirectional binding between string Property and integerproperty
Assembly
0 vote210 views1 answer
Google apps script format date string
Assembly
0 vote217 views1 answer
Dd utility skip
Assembly
1 vote472 views1 answer
The type or namespace name 'IEnumerator' could not be found (are you missing a using directive or an assembly reference?)
Assembly
0 vote214 views1 answer
Assembly mov char
Assembly