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 Topic
- Proprietor have 2 business. One is registered unde
- ITR-4 – Gross Receipts or Turnover for Secti
- Unrelated entries in AIS and Form 26as
- Payment to foreign national
- Internal reconstuction
- IDS Refund – Annexure B & GSTR-3B Match,
- Can i should STCG and LTCG as business income ?
- Capital contribution in Firm
- Form 3CD – Clause 20(b) | ESI Contribution &
- Capital Gains on Dissolution of Partnership
Related Topics
CAclubindia
