/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 vote209 views1 answer
Android studio manually add copyright
Assembly
-1 vote213 views1 answer
Assembly print
Assembly
0 vote208 views1 answer
Set assembly highligh vim
Assembly
1 vote246 views2 answers
Pytorch list gpus
Assembly
0 vote213 views1 answer
Assembly mov char
Assembly
0 vote226 views1 answer
Import pyautogui Traceback (most recent call last): File "<stdin>", line 1, in <module> ImportError: No module named pyautogui
Assembly
0 vote221 views1 answer
Vba hello world
Assembly
0 vote221 views1 answer
Creating a sparse-file with dd
Assembly
0 vote206 views1 answer
Open new terminal window mac
Assembly
0 vote181 views1 answer
Change terminal font color
Assembly