Shazam
10-17-2005, 07:42 PM
I'm trying to create a Image Drop down Box list by using this control.
Private Sub ImageCombo1_Change()
End Sub
I dont have any ideas what code should I put. The Ideas is that When I click on the image combo Box it will display names of the pictures and when I select a name in the list the picture will appear and if I select another name from the list the picture will appears and the other one disappears. Now If its possible I would it could be used on the worksheet but if its not possible I guess we probably be done on a userform.
Does anyone has any ideas ?
I found these 2 links it kind of hard to follow. You'll see a list picture real pictures if that could be done that be great!
http://vba.com.tw/VBAFILE/ActiveX/G0006.htm
I tried to do this method below but it does not work. I go to the image properties_Custom_General_and select_Image List and it tells me <None>.
So I dont know what I'm doing wrong.
http://www.vbforums.com/printthread.php?t=343100
Anyone ?
Private Sub ImageCombo1_Change()
End Sub
I dont have any ideas what code should I put. The Ideas is that When I click on the image combo Box it will display names of the pictures and when I select a name in the list the picture will appear and if I select another name from the list the picture will appears and the other one disappears. Now If its possible I would it could be used on the worksheet but if its not possible I guess we probably be done on a userform.
Does anyone has any ideas ?
I found these 2 links it kind of hard to follow. You'll see a list picture real pictures if that could be done that be great!
http://vba.com.tw/VBAFILE/ActiveX/G0006.htm
I tried to do this method below but it does not work. I go to the image properties_Custom_General_and select_Image List and it tells me <None>.
So I dont know what I'm doing wrong.
http://www.vbforums.com/printthread.php?t=343100
Anyone ?