Macro to loop information into next cell from UserForm

Hello all.

I have been fighting with this problem for a while now.

I created a userform where I want to be able to enter the number of pages I printed (in a text box), then select what printer I used (option button) and have it enter the information in a cell. Then as I enter more information, I want it to continue to enter in cell A2, A3, A4, etc.

I have been able to get it to where the userform puts in all of the information I want but only in row 2 but I can not get it to continue on to the next row and so on.

Can anyone help me.

Thank you.

I have attached my excel sheet so you can understand what I am working with.

Hi

You are over complicating the user form for such a simple task.

You only need one piece of code for what you are trying to achieve.

Delete all your code and program the OK button to do all the work.

I have included a loop to clear the text boxes as a hint towards future development.

Please Login or Register  to view this content.

I tried your macro. However, it is entering data on row 11 and it is not looping data. I need it to continue entering data to the next row once one row has data on it.

Thanks again for your help. I really appreciate it.