can some one tell me how to specify properties of input by user in a text box used in user form ? I want to specify, say only dates or a PAN number. I want the user to receive error message if he feeds something else.
1 Replies
CA Vandana Vaishampayan
(C. A.)
(91 Points)
Replied 18 February 2008
to restrict textbox entry to date use following code
Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
If TextBox1 = vbNullString Then Exit Sub
If IsDate(TextBox1) Then
TextBox1.Value = Format(TextBox1.Value, "MM / DD / YYYY")
Else
MsgBox "Please Enter Date "
TextBox1 = vbNullString
End If
End Sub
Recent Topics
- Nznxnc call me at the end of the day of the
- Cp chod doob zoom vo book book
- Nsje snswk fjw ed le ene djff ne enje ejdd rejje
- Hxjcif the day I have been in touch with me and
- Iska djd djrbdsjebshe sir ur rei ejr reinr the jr
- GST registration for medical shop in Karnataka
- Hsshs me know if you are free number of the
- Chu Kang and the situation of the situation and I
- How to reverse wrong transaction payment in phonep
- Paytm wrong transaction
Related Threads
CAclubindia
