textbox need to be converted in time format

[Pookiemeister]

 startTime = Application.WorksheetFunction.Text(Me.TextBox1.Text, "HH:MM AM/PM")
        MsgBox startTime

This might be a simple task but how can I convert a numerical value entered into a textbox to a time value. No matter what I enter in textbox1, it always returns the value of 12:00 AM. But most Youtube or website tutorials usually use the code above minus the messagebox to convert a numerical value entered into the correct time format. Thank you.

 

[gordsky]

maybe this

startTime = Format(TextBox1, "HH:MM AM/PM")

 

[Pookiemeister]

No matter what numerical value is entered into this textbox, it always returns "12:00 AM". Do I need to declare startTime as something? Right now, it is not declared. Thank you.

 

[dmt32]

if you are entering a numerical value then try using the TimeSerial function & see if that does what you want

StartTime = Me.TextBox1.Value
StartTime = TimeSerial(Val(Left(StartTime, 2)), Val(Mid(StartTime, 3, 2)), Val(Right(StartTime, 2)))
Me.TextBox1 = Format(StartTime, "HH:MM AM/PM")

Dave