Change Cell automaticaly

  • Thread starter Thread starter MD
  • Start date Start date
M

MD

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
 
Essentially, macros don't run while editing a cell. So I don't believe you
can do this in a straightforward manner.
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display entire number in cell 3
conditional formatting for wrongly entered 9 digit numbers 13
Combobox filtering 2
Application.Caller calls from ActiveWorkbook not the actual cell workbook 1
Validate User Input in Dialog box 3
Text Formats 4
Data Validation issue with two date entries Options 4
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1

Back
Top