Results 1 to 3 of 3
  1. #1
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Event not triggered with Data Validation (Excel97)

    I have an application that works fine in Excel 2000 and 2002 but when I test it in Excel 97, I see that the Worksheet_Change() event doesn't get fired when a cell contents is changed by selecting from a drop down list defined by Data Validation. This works as desired in Excel 2000/2002 but not in Excel 97. <img src=/S/cranky.gif border=0 alt=cranky width=18 height=25>

    I need this because the drop down list I'm using (from Data Validation) lets the user display a sub-set of quarters for years 1-5. This is a lot easier than making them scroll back/forth through all the data. I've attached a picture of this data validation list.

    It seems this is just a fact of life for Excel97 but I wanted to know if anyone can think of a clever workaround. It tried having another cell point to the newly chosen list item, but that fails too (the changed cell doesn't trigger the event).

    Deb

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

    Re: Event not triggered with Data Validation (Excel97)

    I guess you could consider using a control from the control toolbox?

    Otherwise I guess the calculate event might do it.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Event not triggered with Data Validation (Excel97)

    Yes I'll probably just not use Data Validation and replace it with a text box. The look will be the same to the end user. It's exactly these sort of gotchas that are the sort of things that really get me jumping when people say (MS mostly but also many people who don't use VBA) that the versions of compatible - NOT!!! <img src=/S/cranky.gif border=0 alt=cranky width=18 height=25> <img src=/S/cranky.gif border=0 alt=cranky width=18 height=25> I've stumbled across so many of these bumps between the three versions and it drives me nuts. It just results in taking much longer to get my stuff released. It'd be easier to just do a regular C/C++ .exe program but then I'd have to do all the GUI myself and that's why I use Excel as the front end.

    Oh, joy.... soon my company is updating us all to Office 2003 - then I'll need to test against four versions of Excel. <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

    Thnx, Deb

Posting Permissions

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