Breaking News: Grepper is joining You.com. Read the official announcement!

vba check if shape name exists

Arno Deceuninck answered on November 25, 2021 Popularity 3/10 Helpfulness 4/10

answer vba check if shape name exists

vba check if shape name exists

Comment

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!"

Popularity 3/10 Helpfulness 4/10 Language assembly

Source: stackoverflow.com

Tags: assembly exists vba

Link to this answer
Share Copy Link