Today's Date Auto Fill in Userform Text box

[MikeeRDX]

Hi, is it possible to create a code to have a text box auto fill with today's date as soon as the user form is opened? Thank you!

 

[Norie]

Add this in the form's Initialize event, change the textbox name if needed.

TextBox1.Value = Date

 

[Rick Rothstein]

Hi, is it possible to create a code to have a text box auto fill with today's date as soon as the user form is opened? Thank you!

Assuming the TextBox is named TextBox1, this UserForm Initialize event code will do that...

Private Sub UserForm_Initialize()
  TextBox1.Value = Date
End Sub

 

[MikeeRDX]

Awesome!!!! Thank you so much!!!!