Userform TextBox Equal To Now

[benntw]

I have a userform with a checkbox and textbox. What I wanted to do is check the box to complete the record for an update. When I check it the NOW() function is setting my time to 12:00AM. What am I doing wrong in my code ?

Private Sub CheckBox1_Click()
If UserForm1.CheckBox1.Value = True Then
TextBox6.Value = Now()
Else
TextBox6.Value = ""
End If
End Sub

If I had +(7/24) after NOW the date and time will populate to my sheet. If I do not have that extra it will not update my sheet with the date/time. I am at a loss for it not updating. I have built similar workbooks in the past with an update command. The only difference is the checkbox.

 

[Micron]

I don't see anything there that updates a sheet - just the contents of your userform textbox. If you're saying that
TextBox6.Value = NOW+(7/24) in that code will cause your sheet to update but
TextBox6.Value = NOW will not, then that makes no sense to me.

 

[benntw]

I don't see anything there that updates a sheet - just the contents of your userform textbox. If you're saying that
TextBox6.Value = NOW+(7/24) in that code will cause your sheet to update but
TextBox6.Value = NOW will not, then that makes no sense to me.

With NOW() or NOW()+(7/24) the time is incorrect. I keep getting the wrong time. I keep getting 12am

 

[Micron]

I keep getting the wrong time. I keep getting 12am

Still not clear where - sheet or userform. If sheet, check your cell formatting.

 

[benntw]

Still not clear where - sheet or userform. If sheet, check your cell formatting.

Sorry, It was the TextBox was not populating the current time. I figured it out.

TextBox6.Value = Format(Now(), "M/DD/YY hh:mm am/pm")

Now when I check the box it populates with the correct time.

 

[Micron]

Funny - I tried it on a userform and it worked just fine.