MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Can't find project or libruary


Posted by Tee on September 30, 2001 5:04 PM

Hi Everyone

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"
End Sub

Many thanks in advance for help.

Cheers
Tee.


Posted by Greg Collett on October 01, 2001 5:02 AM

Tee

Try something along these lines. I suspect that the Format instruction is causong the problem.

Hope this helps.

Cheers


Range("C7").Select
Selection.NumberFormat = "mm/dd/yy"