/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 vote183 views1 answer
Bidirectional binding between string Property and integerproperty
Assembly
0 vote193 views1 answer
Assembly mov char
Assembly
9 votes387 views2 answers
Learn assembly
Assembly
0 vote202 views1 answer
Javafx fxml loader example
Assembly
0 vote189 views1 answer
Z language latex
Assembly
0 vote226 views1 answer
Does filter change original array
Assembly
0 vote195 views1 answer
Latex image textwidth
Assembly
0 vote183 views1 answer
Dataframe.shape return what?
Assembly
0 vote183 views1 answer
Vba concatenate strings and integer
Assembly
0 vote186 views1 answer
How to check if chat is nsfw discord.py
Assembly