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
- Tax filing for the belated payment credit
- Legal service RCM
- OUT OF STATE ADDITIONAL PLACE OF BUSINESS
- Excess claim and paid with DRC03
- Upload of qualified audit report on MCA portal
- Form 26QB on multiple installment
- Is Offering Group Health Insurance Worth It for Sm
- Export of services documents
- AOC4 & CFS,STANDALONE separately
- Gratuity Trust for IT company
Related Threads
Trending Online Classes
-
25 Hours GST Scrutiny of Return and Notice Handling(With Recording)
Industry Expert14 February 2025 -
Survey, Search and Seizure under Income Tax Act 1961
CA Hari Agarwal
CAclubindia
