/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 vote237 views1 answer
Nano error reading lock file not enough data read
Assembly
0 vote247 views1 answer
Assembly language loop example masm
Assembly
0 vote257 views3 answers
How to open chrome in vbscript
Assembly
45 votes242 views3 answers
The answer to life the universe and everything
Assembly
0 vote238 views1 answer
Include code in latex
Assembly
112 votes268 views10 answers
Visual studio code
Assembly
0 vote250 views1 answer
Re optional
Assembly
0 vote256 views1 answer
2su.communications.syr.edu]2su.communications.syr.edu
Assembly
1 vote307 views1 answer
Google sheets conditional formatting custom formula current cell
Assembly
0 vote272 views1 answer
Windows detect system dark mode
Assembly