Hi,

I'm trying to use an if statement for my userform that I'm building like so and want it show like so:

txtempid:

If textempid < 1000 Then textempid = ""
MsgBox "Please enter valid Emp ID", vbOKOnly
Else: textempid.Value
End If

Can someone please help me correct it?