TAPS_MikeDion
Well-known Member
- Joined
- Aug 14, 2009
- Messages
- 622
- Office Version
- 2011
- Platform
- MacOS
Hi guys,
Using the code below works perfectly for displaying the time how I need it to be displayed in my Listbox, but how can this be converted to be displayed in the same way as a label value?
I tried just simply using: Me.SunStart.Value = Format(ws.Cells(SelectedRow, 41).Value, "h:mm AM/PM"), but that was a no-go.
Thank you for any help given.
Using the code below works perfectly for displaying the time how I need it to be displayed in my Listbox, but how can this be converted to be displayed in the same way as a label value?
Code:
AddItem "Sunday"
.List(0, 1) = Format(ws.Cells(SelectedRow, 41).Value, "h:mm AM/PM") 'Sunday Start Time
.List(0, 2) = Format(ws.Cells(SelectedRow, 42).Value, "h:mm AM/PM") 'Sunday Finish Time
I tried just simply using: Me.SunStart.Value = Format(ws.Cells(SelectedRow, 41).Value, "h:mm AM/PM"), but that was a no-go.
Thank you for any help given.