Continue filling cells

[Alendi]

Hi Everybody.

I'm trying to fill a column with numbers (TEXT format to support 000 as text) and other column with numbers (currency format) from a userform, I've attached the sample to get help from you, I don't know where I'm wrong but not work, the function is, when userform pop the first textbox will be selected and the user will introduce a number, minimun 2 digits and maximun 3 digits, numbers must be text format because I need to see as example the number 003, or 023 with 3 digits in the sheet.

When first number is in the textbox must to be writed this value to range C:C looking for the next free cell down, when enter key the second textbox will be selected and able to write in numbers in currency format with a maximun of 10$ determined by a variable, then the user introduce a value in numbers minimun 0,10$ and maximun of 10$ and when enter this value will be sended to the column D:D in the same row and the first textbox will be erased and ready to write other number, and so. the cycle continues writing numbers and amounts till close the userform.

Thanks for your help in advance

[millz]

Hi Alendi, see if this is what you wanted?

[Alendi]

Hi Millz
Thanks for your solution, it work good, only a little detail, the number in textbox2 is currency format but not need "$" sign in it, also when enter a decimal number like 2.25 the enter key doesn't work, I was trying again with help but can't see, can you help again?
Thanks in advance

[millz]

Hi Alendi, try again

[Alendi]

Thanks Millz
It work good, this is what I want, thanks again.
If have other problem I´ll thread it ok? I´m trying to make an application but need to learn so much VBA
Thanks