List Box Time Format

[197574]

I have a lisbox in a userform that has a list of times which are pulled from the excel worksheet. When the user selects the time of choice I get the decimal value for the time selected not the formatted time I would like. I'm probable missing something easy any help on the formatting would be greatly appreciated.

Thanks

Mike....

 

[CraigM]

Are you populating the listbox with the Row Source property, or the AddItem method?

For the latter, use something like this:

Me.ListBox2.AddItem Format(Sheet1.Cells(n, 1), "h:mm")

 

[197574]

Listbox Time Format

I am using a ComboBox instead of a listbox. Sorry for the error. I messed with the line of code a litte and still I'm having trouble. Thanks for the reply...

Mike....