Macro to clear picture from AxtiveX Image

[mgalterio]

I am trying to creat a macro to clear the picture out of the ActiveX Image box. This is my code for inserting the picture. I have 22 of these boxes and the code is the same for each excet each one replaces the 1 next to image with 2, 3, 4, 5 or on and so forth. I would like one macro to erase all pictures if possible.

Any help would be greatly appriciated! Thanks!

Please Login or Register  to view this content.

[Norie]

This will clear Image1.

Please Login or Register  to view this content.

[mgalterio]

I tried using that cod in a macro and got a run time error '424' Object required. There is an image in the box. Any suggestions?

[Norie]

That does work, where do you have the code?

Is it in the same module as the Image1_DblClick code?

[mgalterio]

Thank you!!! I had it in a seperate module. Have a great day!