Hey all!

Does anyone know how to make an excel 2007 dropdown that allows to choose more than one choice?

Thanks,
Joy

__________________
Joy Wilder
Wilder Office Approach

You are wanting a 'list box.' For Excel 2007, here are the instructions:

1. Display the Developer tab
Click the Microsoft Office Button , and then click Excel Options. In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

2.On the Developer tab, in the Controls group, click Insert, and then under Form Controls, click List box .


3.Click the worksheet location where you want the upper-left corner of the list box to appear.

4.On the Developer tab, in the Controls group, click Properties .

To specify the control properties, do the following:

1. In the Input range box, enter a cell reference to a range that contains the values to display in the list box.

2. In the Cell link box, enter a cell reference that contains the list box selection.
The linked cell returns the number of the selected item in the list box. The first item in the range returns a value of 1, the second item in the range returns a value of 2, and so on.

Use this number in a formula to return the actual item from the input range.

For example, a dessert preference form has a list box that is linked to cell C1, the input range for the list is E1:E5, and the items in the range are: "Ice Cream" (E1), "Cake" (E2), "Liqueur" (E3), "Candy" (E4), and "Chocolate" (E5). The following formula, entered in cell B1, returns the value "Liqueur" from range E1:E5 if the value of C1 is 3, based on the current selection in the list box.

=INDEX(E1:E5,C1)

3. Under Selection type, specify how items can be selected in the list box by doing one of the following:

To create a single-selection list box, click Single.

To create a multiple-selection list box, click Multi.

To create an extended-selection list box, click Extend.

Note If you set the selection type to Multi or Extend, the cell that is specified in the Cell link box returns a value of 0 and is ignored. The Multi and Extend selection types require the use of Microsoft Visual Basic for Applications (VBA) code. In these cases, consider using the ActiveX list box control.

__________________
Lily Chambers, The Virtual Office Goddess, LLC
Author "How to Do Your Own Small Business Bookkeeping"

Thank you for your quick reply - I'll give it a try.

__________________
Joy Wilder
Wilder Office Approach