I am in the same boat as you...I have been creating a userform in Excel...and then placing the data into a Excel Spreadsheet...so I can do lookups on it.
This is the code I have been using:
Private Sub bnOK_Click()
'Open the Storage Sheet for the Raw Data
Sheets("Storage").Activate
'Find the Next Row
NextRow = Application.WorksheetFunction.CountA(Range("A:A")) + 1
'Add the entered data to the next avaliable line
Cells(NextRow, 1) = txtFirstName.Text
Cells(NextRow, 2) = txtSurname.Text
Cells(NextRow, 3) = cbDeptarment.Value
Cells(NextRow, 4) = cbManager.Value
Cells(NextRow, 5) = lbSunday.Value
' Add in the Code
Cells(NextRow, 11) = "SARS"
Cells(NextRow, 12) = txtSARS1.Text
Cells(NextRow, 13) = txtSARS2.Text
Cells(NextRow, 14) = txtSARS3.Text
Cells(NextRow, 15) = txtSARS4.Text
Cells(NextRow, 16) = txtSARS5.Text
Cells(NextRow, 42) = txtSARSCOMMENT.Text
'Clear all the Entries Back to Blank
txtFirstName.Text = ""
txtSurname.Text = ""
cbDeptarment.Value = ""
cbManager.Value = ""
lbSunday.Value = ""
txtSARS1.Text = ""
txtSARS2.Text = ""
txtSARS3.Text = ""
txtSARS4.Text = ""
txtSARS5.Text = ""
txtSARSCOMMENT.Text = ""
'Set the data entry focus back to the first entry
txtFirstName.SetFocus
End Sub
Private Sub bnCancel_Click()
Unload Me
End Sub