AfterUpdate?
Manage your personal finances in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: AfterUpdate?

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi,

    Does anyone know why the AfterUpdate Event for controls is not available in my version of Excel97? NB Other events like Click and Change work like normal.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Which control(s) in particular? Not all controls actually have an AfterUpdate event.

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    For example the combobox control, which should have one according to VBA Help.

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    There is an AfterUpdate event for the combobox if you use it on a UserForm, but not if you 'draw' it directly onto a sheet from the Forms toolbox. Not sure why, sorry, my head's a bit fuzzy at the mo.

  5. #5
    New Member
    Join Date
    Apr 2002
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thanks. Is this another Excel bug? At least I know there is nothing "wrong" with my Excel...

    A question alike: when you use EnableCalculation, I have read that you can still calculate ranges, ie Range.Calculate should still work. But it does not. Anyone experienced the same?

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com