Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Cell automaticaly
Good day all,
I've been asked a question that I can't answer.... so here it is.... Is there a way to move the active cell to another one as soon as it fills a criteria without having to hit "ENTER". In other words. In cell A1 a 4 digit number is to be entered. In cell A2 a 2 digit number is to be entered. From cell A1, the user would type 6 digits and as soon as the 4th digit is typed, the activecell would continue to A2. This way the user doesn't need to hit ENTER or TAB. Regards, MD |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Cell automaticaly
Essentially, macros don't run while editing a cell. So I don't believe you
can do this in a straightforward manner. -- Regards, Tom Ogilvy "MD" wrote in message ... Good day all, I've been asked a question that I can't answer.... so here it is.... Is there a way to move the active cell to another one as soon as it fills a criteria without having to hit "ENTER". In other words. In cell A1 a 4 digit number is to be entered. In cell A2 a 2 digit number is to be entered. From cell A1, the user would type 6 digits and as soon as the 4th digit is typed, the activecell would continue to A2. This way the user doesn't need to hit ENTER or TAB. Regards, MD |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Cell automaticaly
Maybe a workaround.
Use an extra column (new column A) and let them type the 6 digit number. in B1: =INT(A1/100) in C1: =MOD(A1,100) MD wrote: Good day all, I've been asked a question that I can't answer.... so here it is.... Is there a way to move the active cell to another one as soon as it fills a criteria without having to hit "ENTER". In other words. In cell A1 a 4 digit number is to be entered. In cell A2 a 2 digit number is to be entered. From cell A1, the user would type 6 digits and as soon as the 4th digit is typed, the activecell would continue to A2. This way the user doesn't need to hit ENTER or TAB. Regards, MD -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to change the pivot chart automaticaly as values in the worksheet change | Excel Worksheet Functions | |||
how to change cell value to uppercase automaticaly when entered | Excel Discussion (Misc queries) | |||
automaticaly change a cell to metric | Excel Discussion (Misc queries) | |||
Cell does not calculate automaticaly | Excel Discussion (Misc queries) | |||
refresh a cell automaticaly each second ? | Excel Programming |