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.
Menu
taxt box properties in user form
Replies (1)
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 :
- Consultation
- E-way notices2222
- Gst file not created
- Regarding 3CEB query
- Omitted E-Commerce Sales Reported in Table 14 but
- Omitted sales shown in GSTR-1 Table 14 but not in
- EWAY BILL TAKE OUT OF OTHER COMPAMY
- Penalty & late fee for late ITR filing
- Business discontinued as Government took possessio
- Which Aviation Services Can Air Ticketing Professi
Related Topics :
CAclubindia
