| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| display cell content based on date criteria | Excel Discussion (Misc queries) | |||
| Why does my cell content display as '############'? | Excel Discussion (Misc queries) | |||
| insert picture from file based on cel value/content | Excel Worksheet Functions | |||
| display a drop-down list based on the content of another cell | Excel Discussion (Misc queries) | |||
| Change picture according to cell content | Excel Programming | |||
Hybrid Mode
