+ Reply to Thread
Results 1 to 4 of 4

"User defined type not defined" error

  1. #1
    Registered User
    Join Date
    07-08-2012
    Location
    Venezuela
    MS-Off Ver
    Excel 2010
    Posts
    62

    "User defined type not defined" error

    Hellow guys,

    I have the followinf code:

    HTML Code: 
    Despite, I've referenced Microsoft Excel 15.0 Object Library and Microsoft Office 15.0 Object Library, I still get the error: User Define Type NoT Defined

    I do not know what to do.

    Help will be appreciated.

    Nelson

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    27,192

    Re: User defined type not defined error

    What line of code is giving the error? I do not get this error when I use the same code.

    Please consider attaching your file. Having your file allows us to see and experiment with your data, layout, formulas, code, and possibly attach a file with a completed solution.

    The paper clip icon does not work for attachments. To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2024
    Posts
    6,203

    Re: "User defined type not defined" error

    delete post.

  4. #4
    Registered User
    Join Date
    07-08-2012
    Location
    Venezuela
    MS-Off Ver
    Excel 2010
    Posts
    62

    Re: "User defined type not defined" error

    Hello 6StringJazzer,

    Appreciate your response.

    The problem came from a sub in a module, I corrected it and macros are doing great.

    Thank you so much.

    Nelson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Compile error: User-defined type not defined
    By VAer in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-12-2017, 10:46 AM
  2. Mac - Compile Error : User Defined type not defined
    By aprildu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-26-2017, 05:02 AM
  3. [SOLVED] Compile Error: User-defined type not defined.
    By VAer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-11-2017, 12:54 AM
  4. Replies: 4
    Last Post: 06-28-2016, 05:38 PM
  5. Replies: 2
    Last Post: 06-26-2016, 02:17 AM
  6. Compile error: User- defined type not defined
    By rolex in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-14-2015, 05:08 PM
  7. [SOLVED] Compile error: User-defined type not defined
    By XmisterIS in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-21-2014, 09:46 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1