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?

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?

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?