Hi Greg
not really understanding what's going on here .. if you'ld like to zip up
the workbook and email it direct to me i'll be happy to take a look -
julied at hcts dot net dot au
Cheers
JulieD
"Greg Brow" wrote in message
...
I am using this code to transfer times from a userform to my template, The
trouble is when I click on any of the cells it automatically places 00:00
in the cell which then causes a conflict on my other sheet's "if" code any
help would be appriciated.
Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
TextBox1.Text = Format(TextBox1.Text, "00:00")
End Sub
Thanks in advance
Greg
|