Userform Combobox to display image name from file

Hello,

My user form titled "sinkinformation" has an image box and a combo box. I'd like the image box to display an image based on what is selected from combo box, titled "sinkstyle".

The following is the code I am using. The problem I encounter is that the combo box will not display the list of file names from the file path specified in the code (C:\sinkstyle). Obviously this means that if the image's file name doesn't populate in the list, there's nothing to select to display that image.

Please Login or Register  to view this content.

I have checked the accuracy of the file path name, file type (.jpg), and other obvious possible errors which might cause this issue.

Please let me know if any additional information is needed to better understand my question or code I am using.

Thank you very much!

Hello manda_w,

In case you are interested in how to load a ComboBox using an Array, here is how...

A 1-D (One dimensional) is considered to be a single row with multiple columns. But, you want each array element to represent a single row in your ComboBox list.

There is a trick called transposing an array. This will switch the rows and columns of the array. That is the rows become the columns and the columns become the rows. This will convert your 1-D array into a 2-D array which you can then assign directly to the List property. This will automatically load the array contents into the ComboBox. Since the first subscript of the ComboBox is zero and the default first element of an array is zero, there is no need to start your array at position 1.

Please Login or Register  to view this content.

Hello manda_w,

The LoadPicture statement expects the a Standard Picture. That is a bitmap, icon, or cursor image. The jpg file would need to be converted to be displayed correctly in the control.