You can use the Calculate event, as described here:
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
Bookmarks