PDA

View Full Version : Solved: VBA Help with Chr(13) problems



nsaint
02-06-2008, 11:53 AM
I wrote some VBA code a little while ago and everythig seemed to be working for me as well as other users of this worksheet form, then things started to break. I ran the code in debug on one of the failing machines and it pointed to a section of the code that called the use of Chr(13), which is a linefeed in a MsgBox I was using for error checking and form completion.

Here is the code. This still works on my computer, but others are having problems with it. I suspect there is a problem on their computer. Does anyoone have any ideas?

MsgBox "You have to enter a Customer Name," & Chr(13) & _
"The User Name Name," & Chr(13) & _
"and the Application name in the form first!"


The error I get is " Can't find Project or Library!" I can't seem to determin whic Library it needs as well.

Bob Phillips
02-06-2008, 12:22 PM
Go into the VBIDE, then menu Tools>References. You will see one ther that is checked but has MISSING in the title. Uncheck it and try again.