Hi All

On a UserForm in TextBox1 - I enter the number 1 fill in all the other Text
Boxes hit enter all the details appear on the sheet in Row 2 starting with
Column A which has the number1 in from TextBox1.
Is it possible to code TextBox1 so that after hitting enter - Number2 auto
appears in TexTBox1 ready for the next row of details to be entered - and so
on down the rows up to a possible 250

Any help much appreciated

Mully