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

With that project active, click on Tools|References.

Look for a reference marked MISSING. You'll have to decide if you need to
replace it or just uncheck it.

The line marked in error may not (will probably not!) have anything to do with
the missing reference.

Geo wrote:

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

--

Dave Peterson