Time from userform

[RJPotts]

Hi,

I'm creating a userform to enter some date into a sheet.

About half of the data the form asks for each time are times. When I tried it after setting out the form they enter (into text boxes) without problem, I'm entering in hh:mm format.

Then I started setting it up to transfer each page of information to a temp worksheet. On the text-boxes I did that with the ControlSource attribute. Is that correct?

If I then enter, say, 02:00 its transferred to the worksheet correctly but appears in the text-box on the form as 8.33333333333333E-02.

Does anyone know what I'm doing wrong & how to fix it?

Rgds & thanks in advance
Richard

 

[jindon]

Hi
One way, writing the code onto form module
Delete ControlSouce first.

Private Sub UserForm_Initialize()
TextBox1.Value = Sheets("YourSheetNameHere").Range("YourRangeHere").Text
End Sub

This transfer what you actually see in the cell, not the value in the formula bar.
So if the cell width is not wide enough to show the data, it will also show ###### in the textbox.