UserForm Question

  • Thread starter Thread starter TotallyConfused
  • Start date Start date
T

TotallyConfused

I have a userform and on the first page I have a text box that I want to show
Now() or Date(). When form is opened date will be visible. Currently the
text box does not show the date when you open it. The bottom part of the
form has a tab control with several tabs The tabs have text boxes and all is
visible. Can someone please tell me why this is happening? Thank you.
 
Check whethe you have placed your code in the right area. Right click the
user form icon from the left treeview>View code and paste the below code..

Private Sub UserForm_Initialize()
Me.TextBox1 = Date
'Me.TextBox1 = format(Date,"mm-dd-yyyy")
End Sub

If this post helps click Yes
 
Back
Top