Set Textbox to "00:00:00" format

[hitman0801]

Hi guys! I am new to vba projects. I am currently creating a userform that will show the value of a specific cell in the "Timer" sheet into the textbox1 in my userform. The cell contains time. However, whenever I try to run the userform the textbox wont show the value of the cell in "00:00:00" format. Please check the codes I'm working on below:

Please see codes below:

Please Login or Register  to view this content.

[/I]
The cell shows:

T1.PNG

then textbox1 in userform shows:

T2.PNG

I already tried adding: Textbox1.value = Format("00:00:00") in the vba but it is not working. It tends to show the value of textbox1 as "12:00:00 AM"



I hope you can share your thoughts with me.

[kev_]

Sample code:

Please Login or Register  to view this content.

Results in this:

TimeInUserFormTextBox.jpg



Welcome to the foum


IMPORTANT
Please click Edit Post on your first post and attach code tags around your code
thanks

Extract from forum rules
3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button). The result will appear like this in the post window:

Please Login or Register  to view this content.

[hitman0801]

Thanks Kev_! This is perfect. You saved me. Anyway, I already edited my post.

[AliGW]

You did not add the code tags correctly. I have done it for you this time.