Consulting

Results 1 to 6 of 6

Thread: VBA View Object panel inaccessible

  1. #1

    VBA View Object panel inaccessible

    Hello, i'm following a tutorial to setup Application events from Use Events with the Application Object | Microsoft Learn.

    There's a section on that tutorial that said

    "After the new object is declared with events, it appears in the Object list in the class module, and you can write event procedures for the new object. (When you select the new object in the Object list, the valid events for that object are listed in the Procedure list.)"

    But when i go check my VBA Window, i found out that the "View Object" button is greyed out alongside the View > Object (Shift+F7) on the menu.

    What did i do wrong?

  2. #2

  3. #3
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,059
    Location
    Welcome to VBAX msstein. Have a look here https://answers.microsoft.com/en-us/...779338e?page=2.
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  4. #4
    Hello Aussiebear, thanks for the reply, the linked discussion seems about them not being able to use Visual Basic at all, mine worked all right but it's only the 'View Object' panel that inaccessible.

    Anyway, I'll try out the steps on the linked discussion to see if it helps

  5. #5
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,059
    Location
    When I tried it last night I had the same result, so I thought maybe I'd missed something. So I downloaded a workbook from PaulKelly on Class Modules and its does the same thing. Perhaps its a MS thing.
    Attached Files Attached Files
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  6. #6
    It might be yes.

    I did some digging last night and ended up with this workaround to access all the events from an object using the procedures list


    Maybe there's more stuff on the View Object panel that aren't on the procedures list but this will do for now, thanks.
    Last edited by msstein; 09-09-2023 at 07:53 PM. Reason: change url to image

Posting Permissions

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