Insert picture based on cell value (unlimited)
Record a macro whilst you insert the picture manually.
Then edit/include that in the required event, probably:
Private Sub ComboBox1_Click()
End Sub
where ComboBox1.Text gives you selected text.
Depends how you are matching the selected name to the required graphic.
NickHK
"djk44" wrote in message
...
I am looking to insert a picture based on a cell value. The exact
application
is to insert the picture of a person based on choosing their name from a
drop-down list. Anybody have any suggestions; VBA or other? Thank you in
advance for the help.
--
djk44
|