ExcelBanter - Formating a returned result.

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

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

- - Formating a returned result. (https://www.excelbanter.com/excel-programming/408915-formating-returned-result.html)

Patrick C. Simonds

Formating a returned result.

The data in ListIndex, 4 is formatted to display time (HH:MM) but the
returned result I get below in does not seem to have the same format. How
can I format the returned result in the HH:MM format?

Other_Routes.TextBox6.Value = .List(.ListIndex, 4)

Dave Peterson

Formating a returned result.

Check your earlier post.

"Patrick C. Simonds" wrote:

The data in ListIndex, 4 is formatted to display time (HH:MM) but the
returned result I get below in does not seem to have the same format. How
can I format the returned result in the HH:MM format?

Other_Routes.TextBox6.Value = .List(.ListIndex, 4)

--

Dave Peterson

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