How can I add information from an visual basic application to an excel spreadsheet?

I am building a simple application for my job to help us add information to a spreadsheet when we do upgrades. I need help. How do I allow the information that is entered into the VB form to be inserted into the excel spread sheet? Each textbox/dropdown needs to be affiliated with a column and each time someone inputs information it of course needs to go to the next row. Any advice on this is greatly appreciated!How can I add information from an visual basic application to an excel spreadsheet?Here's a demo http://www.freewebs.com/swhtam/YA/addMem鈥?/a>

Alt+F11 to see the code on the userform and the module1, the code is simple and annotated, so happy coding

Please contact for more info.How can I add information from an visual basic application to an excel spreadsheet?I would use a global variable that keep track of which row I am (lets call it my_row)



and after every user entry I will put the following code:

Worksheets("Sheet1").Cells(my_row, 1).Value = "my_value1"

Worksheets("Sheet1").Cells(my_row, 2).Value = "my_value2"

....

....

my_row=my_row+1