Results 1 to 4 of 4

Thread: Compile Error? Think its a glitch

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Aug 2000
    Location
    Birmingham, AL
    Posts
    263
    Ok. When the user opens up my form in excel, a form comes up with three buttons. Well, it seems to me that when ever VBA feels like it, it throws up a compile error:

    Compile Error in hidden module: frmReferral.

    frmReferral is the name of my form. Could someone tell me why this is happening. And when I go in to see whats wrong, I delete a part of the code, then put it right back, open it up and it doesn't do that anymore. It seems to me that there is a glitch some where. If you would like to look at the file let me know. Thanks
    Thanks Alot,

    David Gottlieb
    CIW Certified Internet Webmaster
    Web Developer/Designer

  2. #2

    Thread Starter
    Hyperactive Member
    Join Date
    Aug 2000
    Location
    Birmingham, AL
    Posts
    263
    Somebody please take a look at this. I really need this help. Joacim? Are you there. Somebody. Please
    Thanks Alot,

    David Gottlieb
    CIW Certified Internet Webmaster
    Web Developer/Designer

  3. #3
    Addicted Member Supester's Avatar
    Join Date
    Nov 2001
    Location
    The Netherlands
    Posts
    220
    Try unprotecting the VBA code that is calling frmReferral form and any other VBA code that might be triggering this message.

    My guess is that you have made an incorrect statement in protected code, then VBA can't jump to the statement that is generating the error and comes up with this Compile error in hidden module.

    hope this helps....
    We have the technology and we are not afraid to use it

  4. #4
    Addicted Member
    Join Date
    Aug 2002
    Location
    Luton, UK
    Posts
    178
    Haveyou tried sepping though the code in the module ?
    Sometimes there is a more useful message.
    Regards
    BrianB
    -------------------------------

Posting Permissions

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



Click Here to Expand Forum to Full Width