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 |
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 |
All times are GMT +1. The time now is 11:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com