Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
textbox on form
Hi,
I have a userform with a number of text boxes on it for the user to complete. One of the fields is a date field. What I want is when the form is loaded the field called date will automatically insert today's date. Thanks for your help. Glenn Robertson |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
textbox on form
Hi Glenn.
Try this TextBox99.Text = Foramt(Date,"dd mmm yyyy") -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Glenn Robertson" wrote in message ... Hi, I have a userform with a number of text boxes on it for the user to complete. One of the fields is a date field. What I want is when the form is loaded the field called date will automatically insert today's date. Thanks for your help. Glenn Robertson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Set Textbox on a Form to Deafault | New Users to Excel | |||
end down option in a textbox of a form | Excel Discussion (Misc queries) | |||
User Form in VB = TextBox | Excel Discussion (Misc queries) | |||
Text to Form Textbox and back | Excel Programming | |||
Multiple colours in a Textbox on a Form. | Excel Programming |