Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make an autocorrect entry italic
Hi there - please excuse my ignorance - I've never used VBA before so
I do need some help! I would like to make the replacement text into autocorrect formatted into italic text (as it will be latin text) - I have the following, Sub CreateLatin() ItemCount = Application.CountA(Range("Sheet1!A:A")) For Row = 1 To ItemCount ShortText = Cells(Row, 1) LongText = Cells(Row, 2) Application.AutoCorrect.AddReplacement ShortText, LongText Next Row End Sub However, I would like to make the LongText italic- please help me if you can, I'd be very grateful. Regards. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA to Make Check Box Entry | Excel Programming | |||
Italic | Excel Worksheet Functions | |||
Can I make a data entry box? | Excel Discussion (Misc queries) | |||
Lookup and change to italic italic | Excel Worksheet Functions | |||
How do I make a unique entry | New Users to Excel |