/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 vote158 views1 answer
Z language latex
Assembly
112 votes238 views10 answers
Visual studio code
Assembly
0 vote149 views1 answer
Journalctl not showing all logs
Assembly
0 vote155 views1 answer
Openssl public key der to pem
Assembly
0 vote162 views1 answer
Dd utility skip
Assembly
2 votes249 views1 answer
Django template url with parameter
Assembly
0 vote155 views1 answer
Vba check if object exists
Assembly
0 vote167 views2 answers
Chrome version command line
Assembly
0 vote156 views1 answer
Chrome can't change webcam
Assembly
2 votes238 views2 answers
Fatal error: opencv2/core/version.hpp: No such file or directory
Assembly