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