I get the following error message:

Compile Error:
Can't find project or library.

and that high lights "Format" in the following code:

Private Sub TextBox1_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)
TextBox1.Value = Format(TextBox1.Value, "dd-mmm-yy")

Any ideas?
End Sub
--
Geo