Hi,

I actually already asked this one before, but the response was good; I should have mentioned I'm a beginner on Macro's, so I didn't completely understand it.

I have a UserForm that has a mix of ComboBox and TextBox options. Once all fields are filled out, I have a command button (this is where I need the macro) so that when you click on this button, the options are filled out across the columns of a separate spreadsheet. I'd like this to continually happen, every time a new form is filled out, I want the information to appear in the next empty row down.

I won't write down all the options, but just a few examples:
(The first empty row is row 3)

ComboBox1 = Data enters into Column B
ComboBox2 = Data enters into Column C
ComboBox3 = Data enters into Column D
TextBox1 = Data enters into Column E
TextBox2 = Data enters into Column F
ComboBox4 = Data enters into Column G

As so on and so forth, lets say all the way up to TextBox8 = Data enters into Column M. All the data doesn't get input into the columns until the command button is clicked.

There are no dates, times, expenses etc, all information is only text, so no special extra codes needed.

Is there a really really easy VBA code someone could send me to copy and paste and all i need to do is arrange the above ComboBox and TextBox into the correct columns? I would be great appreciative. Someone was able to provide me a macro once before for something similar, unfortunately I no longer have it.

Thank you