/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

9 votes240 views2 answers
Learn assembly
Assembly
0 vote157 views1 answer
Multiply two numbers assembly lmc
Assembly
1 vote201 views1 answer
Google sheets count number of true
Assembly
0 vote148 views1 answer
Sort in assembly pcspim
Assembly
0 vote142 views1 answer
Docker cannot stop container
Assembly
0 vote146 views1 answer
Install retroarch on Linux
Assembly
0 vote79 views1 answer
Change terminal font color
Assembly
0 vote165 views2 answers
Chrome version command line
Assembly
0 vote149 views1 answer
Assembly language loop example masm
Assembly
1 vote112 views1 answer
Pickle write in directory
Assembly