/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 vote191 views2 answers
Convert html to text
Assembly
2 votes230 views1 answer
Func assembly
Assembly
9 votes222 views2 answers
Learn assembly
Assembly
0 vote206 views2 answers
Datauristring pdf open in php
Assembly
0 vote201 views1 answer
Import pyautogui Traceback (most recent call last): File "<stdin>", line 1, in <module> ImportError: No module named pyautogui
Assembly
0 vote183 views1 answer
Vba concatenate strings and integer
Assembly
0 vote190 views1 answer
Sparsefile
Assembly
2 votes235 views1 answer
Django template url with parameter
Assembly
0 vote220 views1 answer
Does filter change original array
Assembly
1 vote205 views1 answer
MOD OPERATOR for register in arm assembly
Assembly