What else am I leaving out, still won't reconize just numbers
If Not IsNumeric(TextBox1.Text) Then
MsgBox "Units Must Be Numeric.", vbExclamation, "Floater Holidays"
Exit Sub
End If