Formula JLI

[Guest]

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

 

[Gord Dibben]

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

 

[JE McGimpsey]

Take a look here:

http://en.wikipedia.org/wiki/Dingbat

and


http://en.wikipedia.org/wiki/Wingdings

 

[Guest]

Here is the code, but I now have it! The thing that mislead me was the macro
recorder creating the text entry using FormulaR1C1. All it is doing is
entering the text, the formatting to windings creates the symbols required.
Why it could not just set the value to 'JDI' I do not know?

Thanks for your help.


ActiveCell.FormulaR1C1 = "JLI"
With ActiveCell.Characters(Start:=1, Length:=3).Font
.Name = "Wingdings"
.FontStyle = "Regular"
.Size = 10
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = xlAutomatic
End With
Range("F5").Select