I'm looking to format some cells to only allow one character per cell. After
the character has been typed in the cell, I would like it to automaticallygo
to the next blank cell without hitting enter or tab.

Do you want to go to the next blank cell to the right or downward?
--
Gary''s Student - gsnu200760


"SieversEQ" wrote:

> I'm looking to format some cells to only allow one character per cell. After
> the character has been typed in the cell, I would like it to automaticallygo
> to the next blank cell without hitting enter or tab.

You can't do this directly in XL - macros are disabled when in Edit
mode, so there's no way to intercept a single character without exiting
that mode (via Enter, Tab, an arrow key, a mouse click, etc).

In any case, formatting doesn't affect cell values or how input is
handled (other than that setting format to Text bypasses XL's input
parser).

You might consider a Userform instead...

In article <CFC01129-DF50-41EA-89F5-(E-Mail Removed)>,
SieversEQ <(E-Mail Removed)> wrote:

> I'm looking to format some cells to only allow one character per cell. After
> the character has been typed in the cell, I would like it to automaticallygo
> to the next blank cell without hitting enter or tab.