Automatic Advance

[Minitman]

Greeting,

I am trying to set up a cell to receive a single keystroke (a letter)
and then advance without having to hit enter or tab. Is this
possible?
And if so, how many ways can it be done?

TIA

-Minitman

 

[Harald Staff]

Hi Minitman

I beliee that is impossible, unless you have a spesific letter in mind. If
so you can activate an OnKey event in the Worksheet_SelectionChange event of
the sheet.

HTH. Best wishes Harald

 

[Minitman]

'Hey Harold,

How about 2 letters? The cell is looking for either a "C" or a "T".

I just checked the vbe help and it appears that "OnKey" is used to
assign a procedure to a key (or keystroke combination). It does not
appear to be tied to any particular cell, but is application wide,
which is not what I need. I need something restricted to a cell or a
small set of cells.

It was worth looking up, just not what I was needing, but thanks for
the reply.

Any other ideas?

-Minitman