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.

rgarber50 wrote:
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





Debra Dalgleish Wrote:

You can use the Calculate event, as described he

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

rgarber50 wrote:

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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html