Format textbox to show Minutes & Seconds

Hi,

I have a userform where I am entering minutes and seconds and then transfer those to my spreadsheet. When they come back to the spreadsheet the numbers are not formatted correctly. In the textbox I enter 2 minutes and 35 seconds: 2:35

When I pull it back to the textbox, I need it to be formatted the same way. How do I do this?

Thanks

Format the range you are putting stuff in with 'special' formatting of "mm:ss" ? (Not through VBA, but through the sheet formatting)

Thanks for the reply... I have tried that, but 02:35 shows back to my textbox as 1.79398148148148

Do you mean textbox in the userform? So then you would need the userform formatted in the same fashion...?

UserForm2.TextBox2.Value = Format(Time, "mm:ss")

You can throw that in as a uhh... as a sub that runs every time the value of the textbox changes -- to ensure it always has the perfect format. I'm sorry I can't get more specific, I'm really not good at this stuff; I'm very learning

Thanks... but still same result. The cell value is changed to mm:ss but in the formula bar it still shows "12:02:35 AM". I added your code and still the same result. I think I am starting to go nuts.