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