View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Relatively new to macros

I would see no role for autocomplete in the question asked. If single
characters are redefined in autocomplete, it would make these essentially
unusable anywhere else in the sheet.

--
Regards,
Tom Ogilvy


"JLGWhiz" wrote in message
...
It is a new area for me, but I was wondering what event the autocomplete
reacts to when it fires to finish what you are typing. Is there a way to
tap
into that event for this purpose?

"Tom Ogilvy" wrote:

If you mean enter in a cell, then no.

when the user is in edit mode, then code doesn't run for any practical
purpose.

--
Regards,
Tom Ogilvy


"Brad" wrote:

One small part of a problem that I have is that I have been asked if
there
exists a way that a user could enter in a one character value (number
or
text) and excel would automatically enter the value and move to a
desginated
location - without using arrows, mouse, or enter key.

I figure if there is a way to do it, it would be through a macro.

Currently reading about the "appliciation.onkey"

Any ideas? Thanks for the help?