Results 1 to 5 of 5
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Application Events? (Excel 2000 >)

    Excel VBA help files talk about Application_Events. (Not Workbook or Worksheet Events). How do I access these Application Events as they do not list in the Object and Procedure drop-downs in the VBA window?
    Regards,
    Rudi

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Application Events? (Excel 2000 >)

    You Access them by creating a class module. Chip Pearson explains how here
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Application Events? (Excel 2000 >)

    Thanx Pieterse.
    The download was useful!

    Can i ask onother question!
    Is it possible to create new events for a workbook or worksheet, or is the list of events fixed?
    I heard somewhere that a person can create new events for an object via class modules....but this was is VB6. can it be done in VBA?
    Regards,
    Rudi

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Application Events? (Excel 2000 >)

    You can create your own events, but it's rather technical. See WithEvents and RaiseEvent for an article about creating events in Access; the same technique applies to other Office applications too. You must have Office 2000 or later.

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Application Events? (Excel 2000 >)

    Its quite some article you sent me Hans. Thanx.
    I will read it up and see what it says! (I may need another vacation to try it out though!!!) <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    Regards,
    Rudi

Posting Permissions

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