do i have to have all the pics on this worksheet - or can i have them on
another?
this is a bit above me - how do i write the code ( i know how to view it,
but not how to enter one)
--
ForeverH :)
"Gord Dibben" wrote:
Only by using VBA
See John McGimpsey's site for one method suing Event code, Data Validation
and VLOOKUP formula.
http://www.mcgimpsey.com/excel/lookuppics.html
OR go to Debra Dalgeish's site for a sample workbook from Bernie Dietrick
for adding pictures to selections.
Alows for more than one picture(or same picture multiple times) to be
displayed based upon a value or item chosen from DV lists
http://www.contextures.on.ca/excelfiles.html#DataVal
DV0049 - ClipArt Selection
Edit the code to suit.
Gord Dibben MS Excel MVP
On Fri, 14 Nov 2008 17:02:01 -0800, ForeverH
wrote:
Can you use the IF formula to insert a jpg?