Hi,
I am new to programming in Excel.Please help me with the following:

I have a button in sheet2 .

1.When i click on the button, i want to create a drop down, populate the drop down
and set this drop down to cell A1 of sheet1.
2.Once the cell A1 of sheet1 is set with the drop down, I want to get the value i select from this drop down, in the script.



Regards,
Anu