Home » Questions » Computers [ Ask a new question ]

Multi-value selection in an Excel cell

Multi-value selection in an Excel cell

There's a way to make an Excel cell kind of a dropdown selection box. You would just go to Data->Validation with a cell or a range of cell selected, select list as the data type and specify the list of values.

Asked by: Guest | Views: 88
Total answers/comments: 1
Guest [Entry]

"See the Forms section in Excel Help for the topic ""Add a list box or combo box to a worksheet"".

From that page (referring to a Form control list box):

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.

And referring to an ActiveX control list box:

To create a list box with multiple
selection or extended-selection
enabled, use the MultiSelect property.
In this case, the LinkedCell property
returns a #N/A value. You must use VBA
code to process the multiple
selections."