/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 vote252 views1 answer
Assembly fibonacci
Assembly
0 vote232 views1 answer
Vmware workstation player disable side channel mitigations
Assembly
0 vote203 views1 answer
Change terminal font color
Assembly
-1 vote249 views1 answer
How to check whether a row contains a numeric value or not in df
Assembly
0 vote231 views1 answer
Wstring to lpcwstr
Assembly
0 vote243 views2 answers
Convert html to text
Assembly
0 vote270 views2 answers
Datauristring pdf open in php
Assembly
0 vote242 views1 answer
Vba hello world
Assembly
1 vote304 views1 answer
Vundle vim-javascript
Assembly
-1 vote253 views4 answers
New year
Assembly