/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 vote343 views1 answer
Error: failed to synchronize all the database archlinux
Assembly
3 votes355 views1 answer
Using shape property in flutter for circular corner
Assembly
0 vote332 views1 answer
Multiply two numbers assembly lmc
Assembly
0 vote316 views1 answer
Import pyautogui Traceback (most recent call last): File "<stdin>", line 1, in <module> ImportError: No module named pyautogui
Assembly
1 vote377 views1 answer
Vundle vim-javascript
Assembly
0 vote313 views1 answer
Error: ‘cv’ is not a namespace-name using namespace cv;
Assembly
0 vote292 views1 answer
Wstring to lpcwstr
Assembly
-1 vote306 views1 answer
Assembly print
Assembly
0 vote353 views1 answer
Cout boolalpha
Assembly
0 vote307 views1 answer
Iterate over tqdm range
Assembly