Hi
I have a user form with text boxes, one that gives a value of the active cell contents of a time in a diary worksheet. These cells are custom formated has hh:mm
The user form text box code is:
Private Sub txttime_Change()
txttime.Value = Format(txttime.Value, "hh:mm")
End Sub
This works well, for all times except 12:00.
When you activate a cell at 12:00 the text box reads 00:05 yet in all other times its ok?
Any ideas whats wrong I have tried various forms of formatting.
Bern
Bookmarks