/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 vote213 views1 answer
Creating a sparse-file with dd
Assembly
2 votes250 views1 answer
Django template url with parameter
Assembly
0 vote210 views1 answer
Vba hello world
Assembly
0 vote242 views1 answer
Havong space between lines of richtext in flutter
Assembly
0 vote202 views1 answer
Enter 64 bit mode
Assembly
0 vote201 views1 answer
How to listen for changes on an ObservableMap
Assembly
0 vote220 views1 answer
Generate random strings only with uppercase letters and digits in Python
Assembly
0 vote217 views1 answer
Error: ‘cv’ is not a namespace-name using namespace cv;
Assembly
0 vote222 views1 answer
Discord bot name of person being tagged
Assembly
0 vote198 views1 answer
Assign value to struct variable
Assembly