/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 vote127 views1 answer
Journalctl not showing all logs
Assembly
1 vote186 views1 answer
Google sheets count number of true
Assembly
0 vote136 views1 answer
Chrome can't change webcam
Assembly
0 vote142 views1 answer
Dd utility skip
Assembly
0 vote132 views1 answer
Socket failed: EPERM (Operation not permitted)
Assembly
0 vote147 views1 answer
Pyplot name axes
Assembly
0 vote133 views1 answer
ARM assembly divide by 2
Assembly
1 vote254 views1 answer
The type or namespace name 'IEnumerator' could not be found (are you missing a using directive or an assembly reference?)
Assembly
0 vote142 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
0 vote131 views1 answer
Iterate over tqdm range
Assembly