I've created a new form with a text field to enter the date. How can I auto-populate the date?
I've created a new form with a text field to enter the date. How can I auto-populate the date?
Hi
In the form_initialize code enter something like
HTHPrivate Sub UserForm_Initialize() TextBox1.Text = Format(Date, "dd/mm/yy") End Sub
rylo
Hi Suburbanght,
If you want to auto-populate Current Date, then use the following formula, else let me know more.
=Today()
You need to say whether you are using a VBA UserForm or a worksheet designed as a form. If a UserForm there are some examples here
http://www.excelforum.com/showthread.php?t=616587
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks