How to automaticly move to another cell after entering more then 4 digits to one cell?

  • Thread starter Thread starter Marvin Hlavac
  • Start date Start date
M

Marvin Hlavac

Hi all,

This may be impossible to do but I want to ask before I dismiss the idea. In
my spreadsheet I'd like to be able to enter credit card numbers in a way
that users would just type the long 16 digit number and after typing more
then 4 digits into one cell cursor would automatically move to the next cell
so at the end there would be 4 cells filled with 4 digits each without users
actually having to hit Tab or arrows.

Thanks in advance,
 
Hi Marvin

It's not possible with spreadsheet cells. You could however build a Userform
for entries that behaves that way and fills cells accordingly.
 
It's not possible with spreadsheet cells. You could however build a Userform
for entries that behaves that way and fills cells accordingly.
Click to expand...



Hi Harald,

It's time for me to learn about UserForms! Thanks.
 
Back
Top