ComboBox linked to a list of names which when a name is chosen changes a picture ?

[1976dan]

Hi guys i have a list of peoples names on a excel spreadsheet.

i would like to use a combobox on a userform so when using the dropdown
box and selecting the persons name a picture changes to the persons name.

is it possible ? in VBA

[trenars]

Yes it is possible. Can you upload file?

[trenars]

If it helps, i use following way:

I have userfor AddData
One of comboboxes has "Line 1", "Line 2", "Line 3", "Line 4","Line 5", "Line 6","Line 7", "Line 8"
I have files: "Line1.bmp", "Line2.bmp", "Line3.bmp", "Line4.bmp","Line5.bmp", "Line6.bmp","Line7.bmp", "Line8.bmp"

Folder destination is stored:Sheets("Admin Data").Cells(3, 4).Value

Please Login or Register  to view this content.

[OnErrorGoto0]

Where are the pictures stored? In a folder, or in the workbook? If the former, go with trenars' code; if the latter, if you can embed them using ActiveX Image controls, you can simply assign the Picture property of one to the Picture property of an Image control on the form.