Excel 2007 : Create drop down on click of button and set this drop down to a cell.

**Anusree** · 09-02-2010, 08:55 AM

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

**Richard Buttrey** · 09-02-2010, 09:01 AM

Hi,

Not quite sure what you mean. Are you trying to select from a pre-determined list of values and have your selection in A1. In that case just use the Data Validation List functionality.
If not why not just enter the Value directly in A1.

In either case then read your data into a script variable with

Please Login or Register  to view this content.

HTH

**Anusree** · 09-02-2010, 11:39 PM

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