+ Reply to Thread
Results 1 to 6 of 6

compile error with “let” in class module

  1. #1
    Registered User
    Join Date
    09-30-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    78

    compile error with “let” in class module

    I am trying to instantiate a module class for which I have let-setters:
    Please Login or Register  to view this content.
    When I do this, excel is throwing an error:
    "Compile error: Definitions of property procedures for the same property are inconsistent, or property procedure has an optional parameter, a ParamArray, or an invalid Set final parameter"

    Here is what I have in the class module:

    Please Login or Register  to view this content.
    An error occurs on all of the public property let lines... Can anyone explain why excel isn't agreeing with?

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: compile error with “let” in class module

    Works fine for me. What's the name of the class module?
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    09-30-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    78

    Re: compile error with “let” in class module

    class module is called "Entry"

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: compile error with “let” in class module

    Where does the rest of the code appear?

  5. #5
    Registered User
    Join Date
    09-30-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    78

    Re: compile error with “let” in class module

    The rest of the code I have attached here, everything relevant in module 2 or the entry module

    I noticed that I can get around the error by not declaring the argument data type, but then I get an "out of stack space" error.

    [ATTACH]Attachment[/ATTACH]
    Attached Files Attached Files

  6. #6
    Forum Contributor pareshj's Avatar
    Join Date
    05-20-2014
    Location
    MUMBAI
    MS-Off Ver
    2007 & 2010
    Posts
    447

    Re: compile error with “let” in class module

    Hi bsapaka,

    Check the property account in Entry class module.

    Variable and property name are same, it is getting recursively called and hence Out of Stack error.

    Also, check the other properties like edate, etc...

    And in Module2, instead of

    Please Login or Register  to view this content.
    keep

    Please Login or Register  to view this content.
    Regards,
    Paresh J
    Last edited by pareshj; 10-14-2014 at 01:36 AM.
    Click on "* Add Reputation" as a way to say thanks

+ 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 in Hidden Module and Compile Error: Can't find project or library
    By Taislin in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-10-2013, 07:03 PM
  2. [SOLVED] Compile Error within class
    By dystopianprotagonist in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-25-2013, 02:20 PM
  3. compile error in hidden module
    By Amit Chauhan in forum Excel General
    Replies: 1
    Last Post: 09-07-2012, 06:22 AM
  4. compile error in hidden module
    By skip in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-14-2006, 04:45 PM
  5. compile error in hidden module.....
    By Patrick in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-11-2005, 05:06 PM

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