Auto Text Entries

C

Chris W

Does anyone out there know if it is possible to create an autotext entry in Excel as can be done easily in Word simply by attaching a code and using F3 to enter text where required.
 
B

Beth Melton

Hi Chris,

Excel doesn't support AutoText like Word. You could use VBA but this
task wouldn't be simple if you want it is work like AutoText does in
Word. i.e. type an entry and press F3 to insert it.

Now, you could use AutoCorrect in both Word and Excel and since the
applications share AutoCorrect entries they would only need to be
created once.

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/


Chris W said:
Does anyone out there know if it is possible to create an autotext
entry in Excel as can be done easily in Word simply by attaching a
code and using F3 to enter text where required.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top