Data Val list Excel 97 fire macro

[rgarber50]

I have a column of cells which uses a data val list for entering data.
The val list is dynamic and resides on the wks. When a user selects
from the val list in a particular cell I would like a macro triggered
which will place the date and time in the cell directly to the right
(ie one column over, same row).

I need help in how to trigger the macro because Excel 97 events are not
fired from data entered using a val list residing on the wks.

Thanks
Richard

 

[Debra Dalgleish]

You can use the Calculate event, as described here:

http://www.contextures.com/xlDataVal08.html#Change

 

[Dave Peterson]

Maybe you could put a button from the Forms toolbar right next to the cell with
data|validation.

Then have the user hit that.

 

[rgarber50]

I've seen this, but it seems to require that the user hit a button t
trigger the macro? Is there no way to make this event driven?

Richard

 

[Debra Dalgleish]

If you read the last paragraph in that section, it describes how to use
the Calculate event. There's no button required. Download the sample
file that's mentioned (ProductsList97Calc.zip), and you'll see how it works.

I've seen this, but it seems to require that the user hit a button to
trigger the macro? Is there no way to make this event driven?

Richard