Hi,

The cell where i want the drop down to appear will be decided dynamically. Its just for a reference that i mentioned A1. Hence, i cant use the data validation list functionality. Also, the list is not predetermined. the values to the list are added dynamically.

1. I have written an event handler for the button in sheet 2. i have some piece of code inside the handler. after that code, i want to create the drop down,populate it and then assign this drop down to a particular cell, say A1, in sheet1.
2. once this is done, i will select some value in the drop down. i want to get the value that i have selected from the drop down.

Please help.

Regards,
Anu