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
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