Excel 2007 : Assigning drop down to a cell using script

Hi,
I am new to Excel. Please help me with the below problem:

I have created a button in sheet 1 and on click of this button i have written a code which will create a drop down and also populate values into the drop down. i want this drop down to appear in cell A10 of sheet 1. How can i ensure this?

Regards,
Anu