Can't use variable to refer to ActiveX Images

On my worksheet I have two ActiveX image objects. This allows me to store images in the sheet, and to pass them to a powerpoint presentation in later processes.

The problem is that I am only able to reference the images explicitly. IE I have to hard code using the name of the object like

Please Login or Register  to view this content.

I have been completely unable to set a variable to the image and perform operations with it. I want to be able to pass the name of an object and have the code work with that

What I want would be something like

Please Login or Register  to view this content.

Any help in clarifying this would be great. If I have to hard code, it'll be a real pain when I have to have more than 2 images

Try something like this...

Please Login or Register  to view this content.

Originally Posted by AlphaFrog

Try something like this...

Please Login or Register  to view this content.

Sorry for the delay in getting back to this. I just became a father earlier than expected.

You code gives an error because .picture is not a property of a shape object.

Congratulations on the kid. Good call on taking care of that first. You passed the first test.

Try something like...

Please Login or Register  to view this content.

I was reading the vba references, and I found this. The name of the shape, and the CODENAME are not the same thing. Some references use the SHAPE NAME. Others the CODENAME.


“You use the code name of a control in the names of its event procedures. However, when you return a control from the Shapes or OLEObjects collection for a sheet, you must use the shape name, not the code name, to refer to the control by name.
For example, assume that you add a check box to a sheet and that both the default shape name and the default code name are CheckBox1.
If you then change the control code name by typing chkFinished next to (Name) in the Properties window, you must use chkFinished in event procedures names, but you still have to use CheckBox1 to return the control from the Shapes or OLEObject collection”
https://docs.microsoft.com/en-us/off...cel.oleobjects


This explains everything that I had wrong. I was simply calling the wrong name.