Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I change an image based on cell value
I want to place a picture of the employee on a Rating form
and it must change based on the employee's name selected from a dropdown combo list box. Thanks Adriaan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I change an image based on cell value
OK,
this is what ya gotta do. Make the for with the combobox and image control. Private Sub UserForm_Initialize() ComboBox1.List = Range("a1:a4").Value ' your range. this will load the combobox with the names End Sub Private Sub ComboBox1_Change() Image1.Picture = LoadPicture("C:\My Documents\My Pictures\" & ComboBox1.Text & ".bmp") ' put your path there and the extension. bmp or gif. End Sub hope it helps. Cesar Zapata "Adriaan vd Linde" wrote in message ... I want to place a picture of the employee on a Rating form and it must change based on the employee's name selected from a dropdown combo list box. Thanks Adriaan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to display image based on if-condition? | Excel Discussion (Misc queries) | |||
insert an image based on a cell value | New Users to Excel | |||
Can i use the IF condition to import an image or change a cell col | Excel Worksheet Functions | |||
DISPLAY Image Based on Logic | Excel Discussion (Misc queries) | |||
Is there a way you can get Excel to change an image in a cell | Excel Discussion (Misc queries) |