Can't find project or libruary
Posted by Tee on September 30, 2001 5:04 PM
I have having trouble with this error message.
I have a program that I designed in Excel and I have made a copy to run on another computer.
Now I have this error message when I try to run a macro with the FORMAT command. What I am trying to do is when the user exits a textbox, the macro will format the date entered.
The line of code is:
Private Sub txtDate_AfterUpdate()
txtDate = Format(txtDate, "dd-mmm-yy")
'MsgBox "PLEASE CHECK DATES IN DATABASE" & vbCrLf & "AFTER ENTERING TO ENSURE THEY ARE CORRECT.", vbCritical, "Check Date Warning"
Many thanks in advance for help.