maybe simple? excel VBA TIME

[instanceoftime]

cell B2 has a time (24hr) 8:23:28 in it.

I want to copy this time into txtbxTime

I tried:

Me.txtbxTime.ControlSource = ("B" & 2)

but the time 8:23:28 is looking like

0.34962962962963

How can I do this?

 

[Markus4]

Hi,

Format(0.34962962962963,"hh:mm:ss")

M.

 

[SkipVought]

Me.txtbxTime.ControlSource = Format(Worksheets("YourSheetName").Cells(2, "B"),"hh:mm:ss")

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[strongm]

A simple CDate should suffice, and display in selected regiona format ...

 

[instanceoftime]

Still ran into problems with the above code... so I

Dim vTime As Date

vTime = Range("B2").Value
Me.txtbxTime = vTime

and it worked

but thanks for your help guys... I'm sure I will be back soon