Case# 4812 - Display gif picture based on cell content

B

Bjørn

Hi,
Software is Excel 2000.
I have received a problem from an end-user that need to have a flag
displayed in a cell. And this flag should change depending on the content
of another cell.
I.e. I would like the checkered flag to appear in column G, whenever
corresponding cell in column B contain the letter "N". And an american flag
to appear whenever the cell in column B shows "UK". And if any cell change
from I.e. "N" to "UK", then the corresponding flag should also change.
(Didn't find a Norwegian and English flag :)
I assume that the only way to do this is with WB programming. Does anyone
know if there exist an easy solution to this problem?
If anyone can help then I could provide a zip file with example.
Thanks for any input.

Brgds

Bjørn Gjerde

KAS IT ServiceDesk

(e-mail address removed)

(e-mail address removed)
 
B

Bernie Deitrick

Bjorn,

I will send you an example workbook that uses the workbook's events to
change graphics based on cell content.

HTH,
Bernie
MS Excel MVP
 
B

Bjørn

Hi Bernie,
Checked out your example workbook.
It worked just the way I needed it.
Thanks a lot.

brgds

Bjørn Gjerde
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy text from cell and paste it in a separate text box (contents tobe linked) 7
Clear Cell Contents based on Criteria of another cell 10
Display cell contents in a text box (shape) and linking 2
Dynamic view of data based on cell content 1
Hover Messages 12
Display picture according to active cell 0
conditional formatting based on cell contents 3
Macro that splits content from cell if given character is found 3

Top