/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 vote325 views1 answer
Bidirectional binding between string Property and integerproperty
Assembly
0 vote312 views1 answer
Chrome can't change webcam
Assembly
0 vote327 views1 answer
Tqdm iterate over range
Assembly
0 vote365 views1 answer
Pyplot name axes
Assembly
0 vote365 views1 answer
Havong space between lines of richtext in flutter
Assembly
0 vote360 views1 answer
Windows detect system dark mode
Assembly
0 vote341 views1 answer
Assembly mov char
Assembly
0 vote377 views1 answer
Cout boolalpha
Assembly
1 vote422 views1 answer
Google sheets check if empty
Assembly
0 vote324 views1 answer
Node js vulnerabilities
Assembly