Convert a Textbox to a time format

[Yoepy]

Hi all.

Is there a way to convert a forms textbox which appears as a minutes and seconds(m:ss) to an actual time format in a particular cell.

When I link the textbox to a cell via the properties it comes in as text (obviously).
I would like a Private Sub Textbox_Change() that will convert the value to a genuine time, so it can be used as a timer.

Thank you

Yoepy.

[dotchiejack]

Do you mean this?

TextBox1.value= format(TextBox1.value,"hh:mm:ss")

[Yoepy]

Sort of dotchiejack. My problem is I need just "m:ss".

I want to enter, for example 1:25 in the textbox and get the result of 00:01:25 in cell "A1". But what I am getting is 01:25:00

[evelynharper]

‘declare a variable as integer

‘name your text box as Textbox1

Dim textboxValue as Integer
textboxValue = Textbox1.Value
By using the value property of textbox any number enter into the textbox will be converted from text to number. After that you can do any mathematical operations just any integer.

Eg:

Msgbox “square of the number is ” & _
textboxValue * textboxValue

[Yoepy]

Thanks evelyn, That works.