Consulting

Results 1 to 2 of 2

Thread: Solved: VBA Help with Chr(13) problems

  1. #1
    VBAX Regular
    Joined
    Nov 2007
    Posts
    31
    Location

    Solved: VBA Help with Chr(13) problems

    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?

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

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

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    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.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •