Can anyone help me with drop-downs, I'm dropping down in my understanding of
this function. Problems a

1. I want the option of selecting from the list or typing in the data cell
without having to use the list.

2. I want to have the option of selecting multiple items from the list and
have them appear in the data cell.

Thanks very very much...

To allow items that aren't in the list, in the Data Validation dialog
box, go to the Error Alert tab, and remove the check mark. There's a
picture he

http://www.contextures.com/xlDataVal04.html#Error

To allow multiple selections, you can use programming. There's a sample
file he

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'DV0017 - Select Multiple Items from
Dropdown List'


VLH wrote:
Can anyone help me with drop-downs, I'm dropping down in my understanding of
this function. Problems a

1. I want the option of selecting from the list or typing in the data cell
without having to use the list.

2. I want to have the option of selecting multiple items from the list and
have them appear in the data cell.

Thanks very very much...


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html