VBA time display in a Textbox

[Sinbad]

Hi All,

need some help jet again.

I have a bit of code that fills textfields etc in a Userform. The data is being pulled from the spreadsheet but in this case the TIME is displayed weirdly.

It shows as 0,46875 and should show 11:15:00 as in the spreadsheet. any suggestions on what I´m doing wrong ?

the line that reads this value is

.STime.Value = Cells(ActiveCell.Row, "V").Value

help as always most appreciated.

 

[Firefly2012]

Hi

You just need to format it:

.STime.Value = Format(Cells(ActiveCell.Row, "V").Value,"hh:mm:ss")

 

[Sinbad]

So easy if you know how.. Thx. Works like a charm.

 

[Firefly2012]

You're welcome!

 

[Sinbad]

Anz ideas whz on Win 8 with Office 2010 it gives me this error _ on Win 7 with Office 2010 it works fine ..

It stops and highlight the word Format int he given code.

.STime.Value = [B]Format[/B](Cells(ActiveCell.Row, "V").Value,"hh:mm:ss")

 

[Firefly2012]

In the VBE look in Tools>References (in the menu bar) and uncheck any that are listed as MISSING.

If this doesn't work, can you tell me what the error is (I couldn't see the image)

 

[Sinbad]

https://www.evernote.com/shard/s253...10786d5aa5c5/c38948aca1b96319958ff4af755888cc

can you see this. let me check the VBA Tools quicly.

 

[Firefly2012]

OK it's definitely a References problem - you need to make sure whatever references you have checked in the list in the Windows7 one are also checked in the Windows 8 one too

 

[Sinbad]

Found it. It is the datepicker control that is not available. Brings me to the next question. how do I get it back. I would like the user to be able to select a date from the pop/up calendar. Any suggestions

 

[Firefly2012]

What's the exact name of the control/reference that includes it in your Windows 7?