Hi All,
i want to Restrict Combobox Selection RowSourse Only and Dont allow null ... anyone can help me in this below code ? 

Private Sub cmdAddData_Click()
Dim RowCount As Long
Dim benefits, total As Single
If Me.cboReporting.Value = "" Then
MsgBox "Reporting Missing", vbExclamation, "Student Data"
Me.cboReporting.SetFocus
End If
'Range("A2") = cboReporting.Text
If Me.cboReporting.Value = "" Then
MsgBox "Reporting Missing.", vbExclamation, "Student Data"
Me.cboReporting.SetFocus
Exit Sub
End If