| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there any way to get an excel formula to display a picture?
Is there any way to get an excel formula to display a picture or drawing of
an arrow showing an increase or decrease in a set of values? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there any way to get an excel formula to display a picture?
Hi
You can write an UDF which uses VBA CharW() function to return an arrow by its ANSI code. ANSI codes for various arrows are in range 8592 - 8660. -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "ShawnC" wrote in message ... Is there any way to get an excel formula to display a picture or drawing of an arrow showing an increase or decrease in a set of values? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there any way to get an excel formula to display a picture?
View this file:
http://www.freefilehosting.net/download/3f3e2 Notice, data in Column B is formatted as Wingdings3. Regards, Ryan--- -- RyGuy "Arvi Laanemets" wrote: Hi You can write an UDF which uses VBA CharW() function to return an arrow by its ANSI code. ANSI codes for various arrows are in range 8592 - 8660. -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "ShawnC" wrote in message ... Is there any way to get an excel formula to display a picture or drawing of an arrow showing an increase or decrease in a set of values? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you use a formula to automatically display a picture in a cell | Excel Worksheet Functions | |||
| display cells over an inserted picture | Excel Discussion (Misc queries) | |||
| picture display on excel worksheet | Excel Discussion (Misc queries) | |||
| How can I conditionally display one picture over another? | Excel Discussion (Misc queries) | |||
| display a picture in excel as an icon | Excel Discussion (Misc queries) | |||
Hybrid Mode
