Excel 2007 : Assigning drop down to a cell using script

Hi,
The cell where i want to put the drop down is not static. Based on a few conditions, i am to decide the cell where the drop down should appear.

Regards,
Anu