ExcelBanter - How do I format a textbox with time

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How do I format a textbox with time (https://www.excelbanter.com/excel-programming/367046-how-do-i-format-textbox-time.html)

Jennifer

How do I format a textbox with time

I am using visual basic editor and have a textbox that I want to display as a
time. When I step off the textbox it displays it in a decimal form.

Mallycat[_15_]

How do I format a textbox with time

Have you tried using format(yourtime,"HH:MM")

--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=560937

All times are GMT +1. The time now is 09:55 AM.