• UserForm_Activate() event not in object browser (2000 SP3)

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » UserForm_Activate() event not in object browser (2000 SP3)

    Author
    Topic
    WSralphad
    AskWoody Lounger
    October 13, 2004 at 9:51 am #410995

    Has anyone any idea why the UserForm_Activate() event does not appear in the object browser?

    Reply | Quote
    Viewing 3 reply threads
    Author
    Replies
    • WSRudi
      AskWoody Lounger
      October 13, 2004 at 10:06 am #887858

      I dont think the User form is documented in the Object Browser at all. You will need to use the help files for guidelines here!

      Reply | Quote
    • WSRudi
      AskWoody Lounger
      October 13, 2004 at 10:06 am #887859

      I dont think the User form is documented in the Object Browser at all. You will need to use the help files for guidelines here!

      Reply | Quote
    • WSpieterse
      AskWoody Lounger
      October 13, 2004 at 10:44 am #887866

      AFAIK events are never listed in the object browser, but I could be proven wrong.

      Reply | Quote
      • WSralphad
        AskWoody Lounger
        October 13, 2004 at 11:14 am #887879

        Events are definitely listed in the object browser.

        Look under MSForms, then the UserForm class. All the other events seem to be there, e.g. AddControl, BeforeDragOver, BeforeDropOrPaste, Click, etc. but not Activate.

        There seem to be several more missing too, e.g. Deactivate, Initialize, Resize, QueryClose.

        Perhaps these events are exposed as part of another interface which UserForm is implementing but I can’t find that interface.

        Reply | Quote
        • WSRudi
          AskWoody Lounger
          October 13, 2004 at 11:39 am #887891

          I see workbook and sheet events in the Object browser. They are represented with a yellow lightning strike! I do not see a MSForms or a UserForm class.???

          Reply | Quote
          • WSralphad
            AskWoody Lounger
            October 13, 2004 at 1:30 pm #887949

            Add a UserForm to you project and MSForms will appear in the library dropdown in the object browser. UserForm is a class in that library.

            Reply | Quote
          • WSralphad
            AskWoody Lounger
            October 13, 2004 at 1:30 pm #887950

            Add a UserForm to you project and MSForms will appear in the library dropdown in the object browser. UserForm is a class in that library.

            Reply | Quote
        • WSRudi
          AskWoody Lounger
          October 13, 2004 at 11:39 am #887892

          I see workbook and sheet events in the Object browser. They are represented with a yellow lightning strike! I do not see a MSForms or a UserForm class.???

          Reply | Quote
        • WSrory
          AskWoody Lounger
          October 13, 2004 at 12:13 pm #887909

          Hi Adam,
          You are quite correct but I don’t know why the events don’t appear. If you browse the Help files, certain events seem to be stored in the Visual Basic help files and others in the Visual Basic Forms help files. Ours not to reason why…

          Reply | Quote
      • WSralphad
        AskWoody Lounger
        October 13, 2004 at 11:14 am #887890

        Events are definitely listed in the object browser.

        Look under MSForms, then the UserForm class. All the other events seem to be there, e.g. AddControl, BeforeDragOver, BeforeDropOrPaste, Click, etc. but not Activate.

        There seem to be several more missing too, e.g. Deactivate, Initialize, Resize, QueryClose.

        Perhaps these events are exposed as part of another interface which UserForm is implementing but I can’t find that interface.

        Reply | Quote
    • WSpieterse
      AskWoody Lounger
      October 13, 2004 at 10:44 am #887867

      AFAIK events are never listed in the object browser, but I could be proven wrong.

      Reply | Quote
    Viewing 3 reply threads
    Reply To: UserForm_Activate() event not in object browser (2000 SP3)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    June 2025
    S M T W T F S
    1234567
    891011121314
    15161718192021
    22232425262728
    2930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.