I am using a textbox on a userform to update a cell in a spreadsheet, & having some trouble with the formatting.
On the spreadsheet the cell with the control source is formatted as a time (e.g.08:00 am) while the textbox on the userform displays 0.33333.
On the userform, I can type in a formatted date such as 09:00 into the text box & this updates the spreadsheet correctly, but it's not a good look !
Any advice on how to format the textbox on the userform to show the time as 08:00 am would be appreciated.
Thanks,
On the spreadsheet the cell with the control source is formatted as a time (e.g.08:00 am) while the textbox on the userform displays 0.33333.
On the userform, I can type in a formatted date such as 09:00 into the text box & this updates the spreadsheet correctly, but it's not a good look !
Any advice on how to format the textbox on the userform to show the time as 08:00 am would be appreciated.
Thanks,