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 treeviewView 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
---------------
Jacob Skaria


"TotallyConfused" wrote:

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.

Thank you very much. This was very helpful. Have a great day!

"Jacob Skaria" wrote:

Check whethe you have placed your code in the right area. Right click the
user form icon from the left treeviewView 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
---------------
Jacob Skaria


"TotallyConfused" wrote:

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.