Link to home
Start Free TrialLog in
Avatar of bbarrene
bbarrene

asked on

Macro to Add Default Picture if Picture is not Detected

I want to be able to add a default picture when a macro is run if there is not a picture already present. I have an excel file that asks for an image and positions it within a cell. I have a button that inserts the picture and names it as "ImagePicture". Now, the picture is not mandatory to be added but I would still like to add a default picture of a symbol to serve as a placeholder.
ASKER CERTIFIED SOLUTION
Avatar of kittenwhisky
kittenwhisky
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bbarrene
bbarrene

ASKER

Thanks for the help.
I needed to change the first code below to the second code below in order for it to work.

Thanks for the help.


Dim ImagePath as Picture

Dim Image Path as Object

Open in new window

Whoops. I meant
Dim ImagePicture as Picture 

Dim ImagePicture as Object

Open in new window