Thursday, November 05, 2009

How to add a combo box to an excel?

Today I tried something new.. How to add a combo box to an excel, whose values come from some range in the sheet. So here you go..
I am using EXCEL 2002. Go to the menu.. View >> Toolbars >> FormsDrag and drop the combo box on the sheet. Rt click the combo box and select "Format Control" property and in the "Input Range" select the range where the values which you want to appear on the combo box exits. This can be a region on the same sheet or on a different sheet. Here I have selected the first row of Sheet2 "Sheet2!$A$1:$A$34"
Click the combobox and you can see the values are populated!