How to access bitmap picture stored as property of image control on userform

I have a userform (ufIcons) where I populated several image controls with icon images (small bitmaps).

I'm looking for a way to access the bitmap and copy it to a cell when the user clicks on the image control.

To be clear, the bitmap is stored directly in the container (i.e. there is no file on the hard drive). I would much prefer to store the images on the userform and avoid storing the images as image files in a folder or as pictures on a worksheet.

The challenge: successfully accessing the bitmap and loading it into a picture/shape/image container to be copied to a worksheet.

End Goal: Copy the image to the activecell when the user initiates a specific UserForm("ufIcons").ImageControl click event

The question: Is there a way to access the bitmap (possibly using VBComponents)?

Here is my code with several different test methods:

Please Login or Register  to view this content.