Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enter Today's Date In A UserForm TextBox
Greetings,
I am trying to enter today's date into a TextBox on a UserForm when I open the UserForm. Anyone know how to do this? Any help will be appreciated. -Minitman |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enter Today's Date In A UserForm TextBox
how about this?
Private Sub UserForm_Initialize() Me.TextBox1.Value = Date End Sub -- Gary "Minitman" wrote in message ... Greetings, I am trying to enter today's date into a TextBox on a UserForm when I open the UserForm. Anyone know how to do this? Any help will be appreciated. -Minitman |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enter Today's Date In A UserForm TextBox
hi
Private Sub UserForm_Initialize() TextBox.Value = Date End Sub regards FSt1 "Minitman" wrote: Greetings, I am trying to enter today's date into a TextBox on a UserForm when I open the UserForm. Anyone know how to do this? Any help will be appreciated. -Minitman |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enter Today's Date In A UserForm TextBox
hi
typo. that should be textbox1 or what ever your text box designation is. regards FSt1 "FSt1" wrote: hi Private Sub UserForm_Initialize() TextBox.Value = Date End Sub regards FSt1 "Minitman" wrote: Greetings, I am trying to enter today's date into a TextBox on a UserForm when I open the UserForm. Anyone know how to do this? Any help will be appreciated. -Minitman |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enter Today's Date In A UserForm TextBox
Steve,
Private Sub UserForm_Initialize() Me.TextBox1.Text = Date End Sub hth, Doug "Minitman" wrote in message ... Greetings, I am trying to enter today's date into a TextBox on a UserForm when I open the UserForm. Anyone know how to do this? Any help will be appreciated. -Minitman |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enter Today's Date In A UserForm TextBox
WOW!
Gary, FSt and Doug - Thanks for the very fast responses! <VBG This is the first time I received three reply's that were so much alike, and all were exactly what I needed. Thank you all very much. -Minitman On Sun, 29 Jun 2008 18:16:09 -0700, "Doug Glancy" wrote: Steve, Private Sub UserForm_Initialize() Me.TextBox1.Text = Date End Sub hth, Doug "Minitman" wrote in message .. . Greetings, I am trying to enter today's date into a TextBox on a UserForm when I open the UserForm. Anyone know how to do this? Any help will be appreciated. -Minitman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
to enter today's date if a cell is blank | Excel Worksheet Functions | |||
in excel how do enter today's date on a laptop | New Users to Excel | |||
in excel how do enter today's date on a laptop | New Users to Excel | |||
in excel how do enter today's date on a laptop | New Users to Excel | |||
Automatically enter today's date as a static entry | Excel Programming |