Using VB In Excel

[ms2001]

Im doing a project for my IT class, its a spreadsheet to keep track of scores for a sporting event. What I want todo is have a VB userform display and then from that you can enter contestant data and event data.

But what im stuck on is how to move data say a name of a contestant from a textbox onto the spreadsheet? anyone got any ideas?

[vass0922]

Use a command button.

Have the user fill out the form, and have a button that says something like "Add Data"

In the commandbutton1_Click() event add the necessary code to populate the spreadsheet with the form data