/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 vote148 views1 answer
Ror loading webview: Error: Could not register service workers: InvalidStateError: Failed to register a ServiceWorker: The document is in an invalid state..
Assembly
2 votes242 views1 answer
Func assembly
Assembly
0 vote148 views1 answer
Android studio manually add copyright
Assembly
0 vote141 views1 answer
Vmware workstation player disable side channel mitigations
Assembly
0 vote185 views1 answer
Discord.py change status to invisible
Assembly
0 vote74 views1 answer
Change terminal font color
Assembly
0 vote141 views2 answers
What do you mean by io address and memory address
Assembly
0 vote140 views1 answer
Eclipse word wrap wrap
Assembly
0 vote145 views1 answer
Html drag and drop anywhere
Assembly
0 vote149 views1 answer
Add text to image ffmpeg command
Assembly