Thread: Formula JLI
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Formula JLI

Sounds like your code is not formatting the cells as Wingdings after entering
text.

JLI formatted to wingdings would leave a smiley face, a frowny face and a right
hand.

Post your code.


Gord Dibben MS Excel MVP


On Tue, 11 Sep 2007 08:56:21 -0700, Nigel RS
wrote:

I recently recorded a macro to enter a collection of symbols into an Excel
cell.

The code created places a formula in the activecell which appears as JLI
subsequent instructions chooses the font name in my case wingdings.

What does JLI mean and how does it know which characters from the wingdings
set to use ?

If I run the macro it works but I do not konw why!

Cheers