/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 vote118 views1 answer
Iterate over tqdm range
Assembly
1 vote189 views1 answer
Slt assembly
Assembly
1 vote238 views1 answer
The type or namespace name 'IEnumerator' could not be found (are you missing a using directive or an assembly reference?)
Assembly
0 vote113 views1 answer
Resize pdf file
Assembly
1 vote180 views1 answer
Custom color bootstrap buttonm
Assembly
1 vote171 views1 answer
Google sheets count number of true
Assembly
0 vote129 views1 answer
Enter 64 bit mode
Assembly
0 vote124 views1 answer
Undefined reference to `cv::inRange
Assembly
0 vote120 views1 answer
Vmware workstation player disable side channel mitigations
Assembly
0 vote118 views1 answer
Include code in latex
Assembly