View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Creating a macro to let a user use a keystroke for repeatative information

Hi
have a look at 'Tools - autocorrection'

--
Regards
Frank Kabel
Frankfurt, Germany


Kelt wrote:
Hi,

I am new to creating macro's. I was wondering if a macro could be
made that will allow a user to press certain keys on the keyboard

that
associated it certain information. This is the current situation.
The user has a list of categories. She would like to have each
category be assocaited with a keystroke so that she doesn't have to
type in the category name everytime. Is there a way that i could
create a macro for this?

Thanks