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?

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?