/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 vote164 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
1 vote231 views1 answer
Latex reference labels
Assembly
0 vote169 views1 answer
Nano error reading lock file not enough data read
Assembly
0 vote171 views1 answer
Nslookup dns stack overflow
Assembly
0 vote165 views1 answer
Dataframe.shape return what?
Assembly
0 vote174 views1 answer
User' does not contain a definition for 'Confirm Password' and no extension method 'Confirm Password' accepting a first argument of type 'User' could be found (are you missing a using directive or an assembly reference?)
Assembly
6 votes266 views2 answers
How to filing the missing data by mean of row in dataframe in pandas
Assembly
0 vote163 views1 answer
Node js vulnerabilities
Assembly
0 vote183 views3 answers
How to open chrome in vbscript
Assembly
0 vote195 views2 answers
Datauristring pdf open in php
Assembly