Excel97/Validation and Change Event

kulbinder · Feb 4th 2003

I have distributed a template to global users with a mix of 97 and 2000 sites.

The template was developed in 2000, where it works fine, but my 97 users have a problem.

It seems that when an item is selected from a validation list, the change event is not fired.

MSDN tries to address this in Article 172832, but the workaround seems irrelevant (or I don't understand how it applies).

Does anyone have any insight in to this problem? Apologies if this has been covered. Thanks for your help.

Insomniac · Feb 5th 2003

You are quite correct, I have had the problem.

Solution is to use the Calculation Event.

Dave Hawley · Feb 5th 2003

Hi kulbinder

Do not have Excel 97 anymore, but try referening the Validated cell with a simple: =A1 , say in cell H1, then use "H1" as the Target cell for the Change Event.

kulbinder · Feb 5th 2003

Dave and Insomniac,

Thanks so much for your responses - you have definitely lead me towards a solution.

In testing your solutions, I discovered another oddity - if your rows have no in-cell formulas, deleting a row still generates a change event, but inserting a row doesn't! Don't need a solution for this one.

Can one praise Microsoft enough?

Regards,
Kulbinder

Excel97/Validation and Change Event

Participate now!

Share

Users Viewing This Thread