Pookiemeister
Well-known Member
- Joined
- Jan 6, 2012
- Messages
- 563
- Office Version
- 365
- 2010
- Platform
- Windows
VBA Code:
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.