/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 vote321 views1 answer
Sort in assembly pcspim
Assembly
0 vote309 views1 answer
Pycryptodome aes 256 cbc
Assembly
1 vote447 views1 answer
The type or namespace name 'IEnumerator' could not be found (are you missing a using directive or an assembly reference?)
Assembly
0 vote314 views1 answer
Journalctl not showing all logs
Assembly
0 vote314 views1 answer
Nano error reading lock file not enough data read
Assembly
0 vote303 views1 answer
Chrome can't change webcam
Assembly
0 vote323 views1 answer
Cron job when not enough time
Assembly
0 vote334 views2 answers
What do you mean by io address and memory address
Assembly
0 vote328 views1 answer
Post a gif in github
Assembly
0 vote395 views1 answer
Cannot open self /usr/local/bin/docker-compose
Assembly