Can u use IF to insert a picture file?

[ForeverH]

Can you use the IF formula to insert a jpg?

 

[Gord Dibben]

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

 

[Shane Devenshire]

Hi,

Functions, all of Excel's built-in functions do not make active changes to
the user interface. Functions are designed to make calculation and return
the results of those calculations to the spreadsheet.

This is also true for custom VBA functions.

Cheers,
Shane Devenshire

 

[ForeverH]

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)