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

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

Kelt

Could be done, but may be just as easy to set up Autocorrect to do this.

xx1 = Category1

xx2 = Category2

xx3 = Category3

Also check out DataValidation to set up drop-down list boxes in cells. User
can select the proper category name from the drop-down list.

For more on DV check out http://www.contextures.on.ca/xlDataVal01.html

Gord Dibben Excel MVP

On 28 May 2004 11:03:58 -0700, (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

Thanks. The autocorrection appears to be very simple to use.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!