Hi Mully

TextBox1.Text = Val(TextBox1.Text) + 1

HTH. Best wishes Harald

"mully" skrev i melding
...
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