Date entry mandatory
 

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.

--
Message posted via http://www.officekb.com

Date entry mandatory
 

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 @




tkraju wrote:
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.

--
Anthony Prescott
http://www.apofficesolutions.co.uk

Message posted via http://www.officekb.com