Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Another Userform Date Problem | Excel Programming | |||
Userform Date | Excel Programming | |||
Date in userform being saved as general not date which affects sor | Excel Programming | |||
Date Selection Userform | Excel Programming | |||
Userform to select start date and end date | Excel Programming |