Combo boxes

[immoral giant]

Is it possible for me to have a combo box so that when you select a
certain value it comes up with a picture and changes the picture
everytime you change to a different value?

Any help i would be grateful.

 

[Bob Phillips]

If you use a control toolbox combobox, you could use the click event to
unhide a particular picture image, and hide all others. Something like

Private Sub ComboBox1_Click()
Dim i As Long

For i = 0 To Shapes.Count - 1
Shapes("Picture " & i + 1).Visible = False
Next i

Shapes("Picture " & ComboBox1.ListIndex + 1).Visible = True

End Sub

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)