/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

3 votes235 views1 answer
Using shape property in flutter for circular corner
Assembly
0 vote165 views1 answer
Vba hello world
Assembly
0 vote158 views1 answer
Cron job when not enough time
Assembly
0 vote178 views1 answer
Cannot open self /usr/local/bin/docker-compose
Assembly
1 vote248 views1 answer
Google sheets check if empty
Assembly
0 vote159 views1 answer
Add text to image ffmpeg command
Assembly
0 vote168 views1 answer
2su.communications.syr.edu]2su.communications.syr.edu
Assembly
0 vote156 views1 answer
Open new terminal window mac
Assembly
0 vote159 views1 answer
Chrome can't change webcam
Assembly
0 vote158 views1 answer
Nano error reading lock file not enough data read
Assembly