Today I have tried for some time to do the following – make a picture ActiveX controller change, following the results of a dropdown button. The problem is that the picture ActiveX controller expects a path to the picture file, and I wanted the picture file to be in the Excel application itself. Otherwise, it is a little bit messy. All I have seen in the net was code, which was doing it really well, but considering the fact that the picture is outside. Thus, I have thought of going around it and doing the following:
- Add the picture in a picture ActiveX Controller in a user form.
- Call the picture from the userform into my Excel spreadsheet.
- Yup! Easy as this! 🙂
The code is really not fascinating, but it works pretty well, without having to save the picture outside the file. Here is also a really small video of the functionalities:
And finally, the code come here:
Private Sub cmb_main_Change()
Select Case cmb_main
img_main.Picture = uf.Image1.Picture
img_main.Picture = uf.Image2.Picture
img_main.Picture = uf.Image3.Picture
img_main.Picture = uf.Image4.Picture
Enjoy it! 🙂