I have three blank text boxes in a UserForm.
All of them should not be blank, or It gets message 'Fill All of Them'
and also, if the value in the third text box is not a Date format, I want a message box "Enter A Date"
Somehow,, my code is not working..
Please somebody help me out..
ElseIf should be used to check the data format of Date. and I don't know how...
This is my current code
If Text1.Value = "" Then
If Text2.Value = "" Then
If Date3.Value = "" Then
MsgBox "Fill All of Them"
ElseIf IsDate(Date3.Value) Then
MsgBox "Enter A Date"
End If
All of them should not be blank, or It gets message 'Fill All of Them'
and also, if the value in the third text box is not a Date format, I want a message box "Enter A Date"
Somehow,, my code is not working..
Please somebody help me out..
ElseIf should be used to check the data format of Date. and I don't know how...
This is my current code
If Text1.Value = "" Then
If Text2.Value = "" Then
If Date3.Value = "" Then
MsgBox "Fill All of Them"
ElseIf IsDate(Date3.Value) Then
MsgBox "Enter A Date"
End If
Last edited: