Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Worksheet_change event (Win XP, Office2003, Excel)

    Hi,

    Have created a workbook under O2003, now I need compatibility back to O'97.

    Most works fine, one oddity has occured.

    Worksheet_change event as suggested by HansV has been implemented. For some odd reason it is not triggering anything in O'97. Thought this has been a standrad for a long time....?
    Any suggestions what to use instead??

    BR
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Worksheet_change event (Win XP, Office2003, Excel)

    Hi,
    What is supposed to be triggering the change? If I recall correctly, there were issues with Data Validation and the change event in Excel 97.
    HTH
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Worksheet_change event (Win XP, Office2003, Excel)

    I'm looking at it right now, but it's really puzzling.

    One cell with data validation seems to work fine, while three others don't.
    Settings under "data validation" are exact the same, so... ???
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Worksheet_change event (Win XP, Office2003, Excel)

    That is odd - to the best of my knowledge, none of them should work in 97!
    You could try linking a cell to the DV cells and using the worksheet_calculate event instead? (though there is no Target argument for that, so it may not work for you)
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Worksheet_change event (Win XP, Office2003, Excel)

    Is there some sort of a "an event trigger" on any of these old properties?

    .Delete
    .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:="=" & sResPos & "1:" & sResPos & intRows - 1
    .InCellDropdown = Boolean
    .ErrorTitle = ""
    .InputMessage = ""
    .ErrorMessage = ""
    .ShowInput = True
    .ShowError = False
    .IgnoreBlank = True

    I loop through the range that causes the problem with a .range.validation.delete and then reapplies the settings. Only data validation not affected is the one that is still working...
    So my thought is that there must be an old - in O2003 not visible - property that is deleted as well...
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

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

    Re: Worksheet_change event (Win XP, Office2003, Excel)


  7. #7
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Worksheet_change event (Win XP, Office2003, Excel)

    Thanks Hans,

    Unfortunately a rather useless KB article, not much help in it.
    Appreciate your efforts though.

    Bests,
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

Posting Permissions

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