I am using an Excel spreadsheet as an input form for keying. Is there a way
to limit the input to a single character per unlocked cell and then have the
cursor move to the next unlocked cell?

No there is no way to get XL to limit the inputs to a single character.
Macro's don't run wheil you are in edit mode and there is nothing built in
that performs that function... Best option is probably to use Tab/Enter to
move the cell.
--
HTH...

Jim Thomlinson


"elevinson" wrote:

I am using an Excel spreadsheet as an input form for keying. Is there a way
to limit the input to a single character per unlocked cell and then have the
cursor move to the next unlocked cell?

Hi,

You can limit the input but it will only check the length when you try
and move to the next cell.

See Debra's page on data validation, specifically the Text Length example.
http://www.contextures.com/xlDataVal06.html

Cheers
Andy

elevinson wrote:
I am using an Excel spreadsheet as an input form for keying. Is there a way
to limit the input to a single character per unlocked cell and then have the
cursor move to the next unlocked cell?

You can limit entry to a single character using Data Validation. Use
Text Length validation setting the length = 1 to accept any single
character. Or create a list of the single characters that you want to
accept as inputs and validate to the list.

SteveM


On Nov 2, 2:56 pm, elevinson
wrote:
I am using an Excel spreadsheet as an input form for keying. Is there a way
to limit the input to a single character per unlocked cell and then have the
cursor move to the next unlocked cell?