• 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

    • 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


    Hours Between the Days

    Thanks For the Quick Response. The amendment in the Formula worked.
    Will Explore More on the new Learning :-)
    Thanks Once again....

    sonbarse Today, 09:32 AM Go to last post

    Hours Between the Days

    NETWORKDAYS.INTL uses a complementary switch (16 in your case) for week ends different from sat/sun . If shifts always end e between start and end hours...

    Pecoflyer Today, 08:14 AM Go to last post

    Hours Between the Days

    I need to calculate the Total hours an Incident/Ticket been live in system. I have incident login date/time & incident closed date/time.

    sonbarse Today, 07:58 AM Go to last post

    How to remove duplicates within a "single cell"

    Use the blow formula:

    =MID(B2&" ",1,FIND(" ",B2&" "))& MID(SUBSTITUTE(B2&" ",MID(B2&"...

    arup1032 Today, 06:10 AM Go to last post

    Recursive table solution

    Here's my attempt, not as elegant as yours cyborgski, but I learnt about recursively passing a table so that was kinda neat......

    tejonno Today, 01:33 AM Go to last post