Please help Userform TextBox1 format appear in hh:mm:ss AM/PM format.

[pedie]

Hi,

Please help. Below is my current code.
I want the TextBox1 to show time format in hh:mm:ss AM/PM format.
When i run the it show in general number format.
Thanks

Private Sub TextBox1_Change()
  TextBox1.Value = Range("DigitalClock").Value
End Sub

 

[Norie]

If the clock is 'ticking' on the worksheet there is probably code that is doing that.

If you want it to also 'tick' on the userform you could add to that code to update the textbox.

Mind you it depends on what code is being used to update the clock, and if that's what you really want to do.

The code for the update might actually be using some sort of on time event and could possibly interfere with any other code in the worksheet.

If you were to add to it to update the userform you might also need to repaint the userform to see anything actually happen.