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.