Minutes And seconds in a userform textbox

[mmmreece]

Hi. I can't seem to find a solution to this. I need to enter a value from a userform textbox (or to as well) to a sheet. When entering on the userform, it works fine if I type "0:1:17" as 1 minute and 17 seconds but I only want to type "1:17" and have this entered to a cell on a sheet as the value meaning 1 minute and 17 seconds. However, everything I try to do fails. Mostly the entered result on the sheet turns out to be 17:00. Any ideas how to work around this?
Just to clarify as the above seems confusing. I want to enter a value similar to 1:17 representing 1 minute and 17 seconds to a userform text box and for this value (upon pressing a command button) to a cell on a sheet as 1:17 (meaning minutes and seconds)

 

[Gokhan Aycan]

Try this (you can also just enter seconds):

Dim strText as String
strText = TextBox1.Text    ' Change TextBox1 to your textbox's name.

Dim Count as Integer
Count = Len(strText)-Len(Replace(strText,":",""))

If Count = 0 then strText = "0:0:" & strText
If Count = 1 then strText = "0:" & strText

' Enter strText to the cell

 

[mmmreece]

Try this (you can also just enter seconds):

Dim strText as String
strText = TextBox1.Text    ' Change TextBox1 to your textbox's name.

Dim Count as Integer
Count = Len(strText)-Len(Replace(strText,":",""))

If Count = 0 then strText = "0:0:" & strText
If Count = 1 then strText = "0:" & strText

' Enter strText to the cell

That worked great. Thankyou