images on a userform

[neilp]

Hi, Wondering if this was possible.

If i have 5 images on a userform, is it possible for them to be changed according to a dropdown.

eg if each image was saved in the same folder according to a set naming schedule ie Peter1.jpg, Peter2.jpg, Peter3.jpg, Jane1.jpg, Jane2.jpg, is there a way that when I select Peter in a drop down, it will update with Peter images and when I select Jane, it will update for Jane images?

Thanks

Neil

 

[davesexcel]

You can change the image control(s)

Private Sub ComboBox1_Change()
    Image1.Picture = LoadPicture("S:\Stairs\Stair Pics\" & ComboBox1)
End Sub