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