Hello,

I have the following problem.
In a userform i have a textbox with contain a time value.
if i fill in the time value 12:00 and save the time the time i correct given
in the excel sheets.
After loading the form again i get 00:05 for 12:00.

if i change the time to 12:01, the time value is correct. Even with 13:00 of
14:00 but not 12:00.
I use the following code:

TextBox6.Value = b6
TextBox6.Value = Format(Me.TextBox6.Value, "h:mm")

B6 is the cell value

can anyone help me

THanks