Consulting

Results 1 to 4 of 4

Thread: Compile Error

  1. #1
    VBAX Tutor
    Joined
    Aug 2020
    Location
    Hampshire
    Posts
    295
    Location

    Compile Error

    I've hit a problem that I just cannot fathom out what is wrong.

    Here is the error and the line that it stops on :-

    2021-07-30_192612.jpg

    I read somewhere online that this might be down to the project references, so here is what I have :-

    2021-07-30_193111.png


    I'm totally stumped.

    Thanks!

  2. #2
    VBAX Sage
    Joined
    Apr 2007
    Posts
    7,950
    Location
    Guessing ...

    It sort of looks like THRONFA is supposed to be the name of a class module in the project
    ---------------------------------------------------------------------------------------------------------------------

    Paul


    Remember: Tell us WHAT you want to do, not HOW you think you want to do it

    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

  3. #3
    Or a missing userform THRONFA
    Graham Mayor - MS MVP (Word) 2002-2019
    Visit my web site for more programming tips and ready made processes
    http://www.gmayor.com

  4. #4
    VBAX Tutor
    Joined
    Aug 2020
    Location
    Hampshire
    Posts
    295
    Location
    Thanks to you both for looking at this. Yes, I had the default UserForm name.

    Now working okay!

Posting Permissions

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