ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Enter Today's Date In A UserForm TextBox (https://www.excelbanter.com/excel-programming/413307-enter-todays-date-userform-textbox.html)

Minitman

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

Gary Keramidas

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




FSt1

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


FSt1

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


Doug Glancy

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




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