How to incorporate images into user form.

[bralew]

Hi,

I'd like to incorporate images into my user form when I select a component from a pull down menu. Does anyone have any good advice on how to start? For example, should I store the images within the excel file itself or ask
the code to access a different XL file (which already exists and so will negate the need to fill the current XL file!). What's the best way to do this?

[davesexcel]

You could have the images in a separate folder and select the images from a combobox on the userform

[bralew]

That's what I thought. I've located the folder and got some rudimentary code. I have a drop down menu in the form of a combobox but not sure where i should insert the file, perhaps a frame? What do you think?

[davesexcel]

Add the "image" control to the Userform

Then populate the combobox when the userform opens

Please Login or Register  to view this content.

Then when you select the picture from the combobox, it will fill the image control

Please Login or Register  to view this content.

ImageControl.png

[bralew]

Great, thanks for your input, I'll give it a whirl

[bralew]

Well here's where my limitations kick in. I've got some basic code but I imagine its full of errors. The basic functioning asks the ComboBox1 to access a directory of pictures and load them into ImageBox called Image1Any assistance would be greatly appreciated. Here's the code:

Please Login or Register  to view this content.