Time set again

[socko139]

I tried this posting before, but no luck so far. I want to create a Form in excel with a macro button. When this button is clicked it will take the system time off the computer and post it to a text box. The code I wrote for the macro button was:

Private Sub CommandButton1_Click()
Me![TextBox1] = mytime
End Sub

..but no luck . . Am I leaving anything out of the code? every time I push the button I receive no errors.. but nothing happens.. ..

Any help would be great!! Thanks

 

[Travis]

Try replacing myTime with Time()

 

[socko139]

Thanks. . .worked perfect!!! !!!!!!!!