Case# 4812 - Display gif picture based on cell content

  • Thread starter Thread starter Bjørn
  • Start date Start date
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)
 
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
 
Hi Bernie,
Checked out your example workbook.
It worked just the way I needed it.
Thanks a lot.

brgds

Bjørn Gjerde
 
You must log in or register to reply here.

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

Clear Cell Contents based on Criteria of another cell 10
Dynamic view of data based on cell content 1
Hover Messages 11
conditional formatting based on cell contents 3
specify a specific column to input text based on another cell's content 14
Cell formatting based on date when value was last modified...? 2
problem with 'flagging' monthly anniversary dates 1
Copy Rows based on column value 2

Back
Top