Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I set specific cells for mandatory entry? | Excel Discussion (Misc queries) | |||
Mandatory Cell Entry | Excel Discussion (Misc queries) | |||
making cells mandatory entry? | Excel Programming | |||
Mandatory entry for a group of cells? | Excel Discussion (Misc queries) | |||
Making Cell Entry Mandatory | Excel Discussion (Misc queries) |