And where would that date be entered? Adjacent to the dropdown cell? On
another worksheet?

Do you want that date to be static?

If so, VBA event code would be the way to go.

Otherwise a formula using TODAY() function should suffice.


Gord Dibben MS Excel MVP

On Thu, 17 Jan 2008 18:23:01 -0800, aeddave
wrote:

Is there a way (preferably not with VBA) to assign a date to a new record
when a cell is a certain value? In this instance, when a particular cell
shows "Closed/Won/Lost" (selected from a drop down) I want to assign a date
automatically.

Thanks in advance.