open image in the userform based upon the condition

K

krishnaa_kumarr88

New member
Joined
Sep 30, 2014
Messages
26
Reaction score
0
Points
0
Hi,
Does any one knows how to show the image in the right hand side of the userform based upon the condition.
Say example,
i have userform with following list
1. Name (combobox)
2. Age (will come automatically based upon the name selection)
3. Occupation (will show automatically based upon the name selection)
I would like to create a picture box in the right hand side of the userform which shows the image for the respective name. ( i have more than 30 names).
Please help me guys,
Thanks
 
Why don't you help us by posting a sample workbook ?
 
Try this.
Need a full path and filename
Also not all image types are supported

Code: 
Private Sub ComboBox1_Change()
    Image1.Picture = LoadPicture("C:\temp\" & ComboBox1.Text & ".gif")
End Sub
 
You must log in or register to reply here.
Back
Top