Excel - 2000 or 97 conversion - macro problems

[ajw150]

Sorry, right, let me try an clear it up.

Situation is:

At the moment a user can click on a data validated cell and a dropdow
list appears. There are three options, which all bring up a selectio
of different cells. (Change event). The selections then contain mor
data validated cells. This works fine in excel 2000+ but obviously, no
97. I need to find a way of making this possible. I have tried debr
dalgleish's example, but can't get the cells to work.


Hope thats helps

Andre

 

[Dave Peterson]

One of Debra's suggestions was to add a button near the cell that
would start the macro. That didn't work for you?

And you may want to consider using a combobox from the controltoolbox
toolbar.