limiting text entry of columns

[tobypitblado]

Is it possible for me to set-up a spreadsheet for others to use but will
limit the options of the data that they can enter (text only), so that they
may only chose from a list which they can check more than one option (similar
to the filter function), this would be similar to how e-cert works??

 

[Ken]

Data ... Validation ... List ... (List of acceptable entries separated by a
comma) ... or ... (Range containing acceptable entires ) ... Select "in cell
drop down" ... Set "input" &"output" warnings as appropriate.

HTH ... Kha

 

[tobypitblado]

Thanks Ken, I got the lists to work now, i was looking in the right area but
was trying 'custom' instead of 'list'. With the lists though i can only
enter one choice, is it possible to select multiple entries??

 

[Gord Dibben]

Debra Dalgleish has a sample workbook with code that can do this.

DV0017 - Select Multiple Items from Dropdown List-- Select multiple items
from a dropdown list; an event macro stores selections in adjacent cell, or
in same cell. DataValMultiSelect.zip 18kb updated 22-Feb-07

http://www.contextures.on.ca/excelfiles.html#DataVal


Gord Dibben MS Excel MVP