• Error Messages: User-Defined Type Not Defined

    There are a great many errors that we can run into when programming, and just on of those is a Compile Error, specifically "User-Defined Type Not Defined".

    This error could mean one of a few different things, which may not all be listed here. Two of the most common, however, are:
    1. You are trying to create your own Constants and did not declare the Enum. (For an example of this, see my article on Creating Your Own Constants For Functions)
    2. You are automating an external program, (using Early Binding,) and forgot to set a reference to the required library.

    The steps that are listed below are assuming that you need to set a reference to PDFCreator in order to use some one of the PDFCreator examples on this site. Be aware that this could just as easily be applied to setting a reference to Word, Access or any application that you are attempting to set an Early bind to.

    To set a reference:

    • Enter the Visual Basic Editor (VBE)
    • Go to Tools|References
    • Scroll down the list until you find the library that you need and check the box:
    • Click OK, and your reference is set

    Hints:
    • To move quickly down the list, click an item and then press the first letter in the reference name. ("P" for PDFCreator.) You'll jump right to the "P" section of the list without having to scroll all the way down.
    • Remember that most Microsoft libraries are prefaced with Microsoft. If you're looking for the Word Object library, look for Microsoft Word

     

    I'm afraid that you must be logged in to comment or leave a testimonial. I wish it could be otherwise, but I'm trying to keep my site spam free for everyone's benefit. If you don't yet have an account it's completely free to sign up, and a very quick process. Simply click here to Register. Not only can you post a comment here, but it gives you full access to posts questions in our forum as well!

     

    If you already have an account, and just haven't logged in yet, what are you waiting for? Login Now!

  • MVP Logo
  • Recent Forum Posts

    Pecoflyer

    I need help with pivot table

    Yes it is
    And Google is your friend http://www.contextures.com/xlPivot08.html
    There are many other tutorials / examples out there. Don't hesitate...

    Pecoflyer Today, 09:33 AM Go to last post
    gohardrgohome

    Data Entry

    Yes, I think this will work. Looks like the only way is to have multiple lines of info for the individual that is dealing with more than one company for...

    gohardrgohome Today, 02:45 AM Go to last post
    Flyboy65

    Data Entry

    Is this close to what you are after?...

    Flyboy65 Yesterday, 10:58 PM Go to last post
    Hercules1946

    IF functions

    In the above part of the function, the brackets are not necessary, as it makes no difference which calculation is made first....

    Hercules1946 Yesterday, 10:30 PM Go to last post
    Logit

    Data Entry

    You could place all of the client's investments on one row. Just dedicate more columns to the total number of investment options.

    John Inv...

    Logit Yesterday, 09:35 PM Go to last post