Go AD-Free with CAclubindia Pro and Daily WhatsApp Updates. Subscribe Now!

taxt box properties in user form

Atul Patankar (Chartered Accountant) (24 Points)

06 February 2008

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.

Reply
Follow
Share

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