Case# 4812 - Display gif picture based on cell content
 

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

Case# 4812 - Display gif picture based on cell content
 

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

"Bjørn" wrote in message
...
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

Case# 4812 - Display gif picture based on cell content
 

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

brgds

Bjørn Gjerde


"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
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

"Bjørn" wrote in message
...
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