VBA to insert userform information into columns

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

I used a public control array. I would normally set the Tag property for those controls manually. Here, I did it for you.

I also commented how to do it more "simply" should you want to use that method istead. Button2 shows how you can iterate the control array and do whatever you like, like clear the contents easily.

Please Login or Register  to view this content.

Thanks Kenneth. That didn't work unfortunately but not to worry. I'll just set up a basic spreadsheet where staff can just type everything in the cells instead.

That's fantastic bakerman2, thank you so much!

Sorry, one last thing. What can I add to that so that once the commandbutton is clicked and everything is inserted, it then clears all the fields?

All good, figured it out, thanks again!