/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

-1 vote367 views1 answer
How to check whether a row contains a numeric value or not in df
Assembly
2 votes479 views2 answers
Fatal error: opencv2/core/version.hpp: No such file or directory
Assembly
1 vote425 views2 answers
Pytorch list gpus
Assembly
2 votes464 views1 answer
Django template url with parameter
Assembly
-1 vote367 views1 answer
Discord bot edit message
Assembly
0 vote385 views1 answer
Post a gif in github
Assembly
1 vote400 views1 answer
Latex reference labels
Assembly
0 vote374 views1 answer
Error: ‘cv’ is not a namespace-name using namespace cv;
Assembly
0 vote365 views1 answer
__init__() got an unexpected keyword argument 'categorical_features'
Assembly
0 vote351 views1 answer
Chrome extension debug log messages
Assembly