Displaying time as 1:00PM (etc) for a Label Value?

[TAPS_MikeDion]

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?

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.

 

[Fluff]

Change .Value to .Caption

 

[TAPS_MikeDion]

Oops, sorry Fluff. My mistake. I meant to say TextBox, not Label.

 

[Rick Rothstein]

I tried just simply using: Me.SunStart.Value = Format(ws.Cells(SelectedRow, 41).Value, "h:mm AM/PM"), but that was a no-go.

In what way was it a "no-go"? Please describe happened...

Did you get an error? If so, what was it?

If not, what actually happened and what were you expecting to happen?

What was in the cell at the time of the "no-go"?

 

[TAPS_MikeDion]

Hi Rick,

I just went to go through it again so I could answer all of your questions, and for whatever reason...It worked using what I tried before (what you have in your quote from me) that didn't work.



Everything is all set. Thanks anyway!

 

[Fluff]

Glad it's working & thanks for the feedback