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
- What is the easy way to do CA- through foundation
- Schedule FA query for this AY 2026-27
- Business income source for husband and wife
- Set off of LTCL against STCG under section 536(2n)
- Audit Workflow tool
- Is CA through direct entry easy for a commerce stu
- Dividend and withholding tax - DTAA- RSU
- NRI Query: Capital Gains Tax Exemption under Secti
- Royalty payment to UK
- Calculate ITR2 tax with equity and non equity prof
Related Topics
CAclubindia
