Excel 2007 - ComboBox change picture on form (from C drive fodler) I want captions change

[MisterTRIM]

Hi,
I have this code, that partially works, it displays the picture on a vb from according to my combobox selection...
I also want a certain LABEL text to be displayed according to the picture selected..... (ALL LABELS are currently set to not visible)
What am I doing wrong here ?

Please Login or Register  to view this content.

Anyone?
Thanks

[Tinbendr]

Is there any value assigned to the caption?

Please Login or Register  to view this content.

[MisterTRIM]

Hi, thanks, this code do a bit of job...

Please Login or Register  to view this content.

It is messy code...Not sure how the numbers of selected values correspond with choosing a correct picture...meaning, is the correct label displayed when certain picture is selected?
Cheers
Going to sleep, its 10:40 in Australia ...PM....
cheers

[Tinbendr]

What I do is to store the description in column 2 of the combobox. When a selection is made, then you have to corresponding label at your fingertips.

Please Login or Register  to view this content.

You really should use a different naming convention for your objects. And try to keep names short.

Combobox1 should be something like cboxDiagram. The label: lblDiagram. Naming linked objects the same except for the function.