My apologies!
I found the solution at this site..
http://www.excel-easy.com/vba/examples/dependent-combo-boxes.html
Private Sub CommandButton1_Click()
Dim RowCount As Long
Dim benefits, total As Single
If Me.txtName.Value = "" Then
MsgBox "Please enter a name", vbExclamation, "Employee Data"...