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?
|