Bev,
It sounds as if you are creating lists in Excel and transferring/pasting
the data into Word. Formatting done in Excel is preserved when moved
into Word.

Microsoft Word has the ability to format data using Auto Correct
In Excel you cannot format text using Auto Correct.
Also, the link you posted has code to be used in Word, not Excel.

In Excel, you would have to have the data entry people, highlight (select)
the latin text and click the Italic button on the Excel toolbar.

It would be possible in Excel, using VBA code, to change specified text
to Italic. This would have to done after the lists are complete.
The code would search against a supplied list of terms, find those in the Excel
list and change the font style.
Since you have not used VBA before, creating that code is probably
best left to a paid consultant.
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




"Beavy"
wrote in message
Hi Jim - sorry I seem to have omitted a rather important bit of info -
the autocorrect of the latin names will actually be used in Word - and
I had thought that the autocorrect text could be formatted? There is a
link where a company has done something similar -
http://www.biologicalrecordscentre.g...italicise.html but as
I said, my VBA is effectively NIL - the code above has been snaffled
from a website too! This is a request from one of our staff members
and am trying to see if it can be done as the admin teams have to type
up large field reports full of latin names, so they wish to use a
standardised 3-4 code e.g abk and when they press space , for
Ablepharus kitaibelli (in italics) to come out instead.
Regards,
Bev.