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


--
rgarber50
------------------------------------------------------------------------
rgarber50's Profile: http://www.excelforum.com/member.php...o&userid=11350
View this thread: http://www.excelforum.com/showthread...hreadid=474583