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