Search
 
SCRIPT & CODE EXAMPLE
 

ASSEMBLY

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!"
Comment

PREVIOUS NEXT
Code Example
Assembly :: set assembly highligh vim 
Assembly :: ARM assembly divide by 2 
Assembly :: cout boolalpha 
Assembly :: visual studio change assembly name 
Assembly :: import svg in google slides 
Assembly :: io mapped io and memory mapped io in 8085 
Assembly :: flutter button border radius 
Javascript :: jquery vslidation remove spaces from input 
Javascript :: how to install react router dom version 5 
Javascript :: login to discord with token 
Javascript :: ts ignore in jsx 
Javascript :: shopify comment code 
Javascript :: jquery display none 
Javascript :: jquery accept only excel file 
Javascript :: get parameter from the actual url javascript 
Javascript :: jquery slim min js url 
Javascript :: react native textInput numbers only 
Javascript :: jquery prevent form submit 
Javascript :: javascript get url 
Javascript :: js split array in half 
Javascript :: js loop through array backwards 
Javascript :: remove commas from string javascript 
Javascript :: javascript capitalize string 
Javascript :: dino game 
Javascript :: bootstrap modal title center 
Javascript :: jquery submit form ajax 
Javascript :: regex password uppercase lowercase number special character 
Javascript :: node-fetch post request example 
Javascript :: javascript replace space by underscore 
Javascript :: how to hide header in react navigation 
ADD CONTENT
Topic
Content
Source link
Name
8+8 =