Sending Data From User Form To First Empty Row Of Sheets

[bakerman]

Paul, some coding tips

1.Preferably use the List-method to fill Combobox instead of AddItem-method

2.Much easier way to check for user-input is to use the Tag-proprty of each object. Especially when using larger amounts of objects on your userform it's much more compact than listing them one by one.

3.Write data in one time to sheet instead of writing them object by object.

4.Use TypeName-properety to clear fields instead of listing them one by one and clearing.

Remember that every line of code has to be read before execution so the less lines in your code the faster it will be executed.