Date entry mandatory

  • Thread starter tkraju via OfficeKB.com
  • Start date
T

tkraju via OfficeKB.com

Date entry in a textbox on a user form is mandatory,and when the textbox is
focussed at initial stage(when cursor blinks on textbox) msg"Enter Date in
"mmddyy" format".Which event code will give me this results.
 
C

Crowbar via OfficeKB.com

Hello,

Just test this to see if its what you require,

create a userform with 2 textboxes and 1 label

then paste this code into the userform

Private Sub TextBox2_enter()
Label1.Visible = False
End Sub

Private Sub TextBox1_Enter()
Label1.Visible = True
End Sub


When selecting between the two text boxes, the label will appear then
disappear.

If you need anymore help you can get me @

(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validations with messages in userform 0
userform textbox returns changeable date 4
Firing Event in another user form 1
user input recorded twice on excel sheet 7
How do I set focus (and select text) on a text box on a modeless userform? 0
Help with specific textbox entry... 4
date entry in userform textbox 7
How do I create a mandatory field in Excel 1

Top