/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 vote200 views1 answer
Discord.py change status to invisible
Assembly
0 vote158 views1 answer
Windows detect system dark mode
Assembly
0 vote178 views1 answer
Generate random strings only with uppercase letters and digits in Python
Assembly
3 votes238 views1 answer
Using shape property in flutter for circular corner
Assembly
-1 vote149 views4 answers
New year
Assembly
0 vote176 views2 answers
Chrome version command line
Assembly
0 vote159 views1 answer
Scanf prototype in c
Assembly
0 vote170 views1 answer
Multiply two numbers assembly lmc
Assembly
0 vote161 views1 answer
Vba and
Assembly
0 vote159 views1 answer
Post a gif in github
Assembly