View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KPSE
 
Posts: n/a
Default need help with a form

Would there be a way of writing an IF statement or macro that would verify 1
character typed then move to the next cell?

Gord Dibben wrote:
Excel has no way of knowing if you are finished with data entry in a cell unless
you give it some help.

This help can be using the enter key, tab key or an arrow key.

In short, there MUST be a trigger Excel recognizes.

Gord Dibben MS Excel MVP

Hello:
I have searched this forum for an answer, and found some really nice replies

[quoted text clipped - 7 lines]
the form, I've posted it he http://www.tjrvsales.com BLANK_MONTHL_DMV_REPORT.xlt
Any help would be greatly appreciated!