Date on UserForm
 

How can I get a date stamp on a User form when it opens? I tried a textbox
with =Date() and =Now() neither works. Any help will be greatly appreciated.
Thank you.

Date on UserForm
 

You can use this event that run when you open your userform

Private Sub UserForm_Initialize()
Me.TextBox1.Text = Format(Date, "mm-dd-yyyy")
End Sub


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"TotallyConfused" wrote in message
...
How can I get a date stamp on a User form when it opens? I tried a textbox
with =Date() and =Now() neither works. Any help will be greatly appreciated.
Thank you.