Hi there,

I have a userform with some ComboBox and TextBox options. I have a command button also titled "Submit".

Is there a macro where when I click on Submit, the information from the ComboBox and TextBox are inserted into individual row cells? It's a type of records management system.

Example:
ComboBox1 is a Title, when I click on Submit, I want the contents of the ComboBox to be inserted into the 'Records' worksheet in column A, row 3

TextBox1 is a persons name manually entered, when I click on Submit, I want the contents of the TextBox to be inserted into the 'Records' worksheet in column B, row 3.

So on and so forth. I don't have submit buttons next to every option. There are about 10 options to go through. Once the tenth option is filled out, then I would click the 'Submit' button. So each option would appear in a separate column but all on the same row.

Once this is done, I can create another record, the same thing would happen but the information would appear on row 4 instead, then row 5 and so forth. The options won't change, so the columns would always be the same ones.

Hopefully that makes sense. I know you can do this type of thing in Access but we don't have that downloaded at work.

Thanks