software

Hello --

We've got no problem in creating a list for a drop down box in Excel and
assigning the list to a cell, etc. but how can you set it so that you can
select multiple values? For example, if the drop down list includes
1,2,3,4,5,6 as possible values, how can I get it to allow me to select 1 and
3 or 1, 3, 5 and 6 all at once (like you would typically expect to do by
holding down the CTRL key while selecting each value)?

Your help will be much appreciated! :-)
Nancy

Use a Listbox (Control Toolbar) with the MultiSelect property set to
quot;fmMultiSelectMultiquot;.

quot;Nancy @ CHRquot; wrote:

gt; Hello --
gt;
gt; We've got no problem in creating a list for a drop down box in Excel and
gt; assigning the list to a cell, etc. but how can you set it so that you can
gt; select multiple values? For example, if the drop down list includes
gt; 1,2,3,4,5,6 as possible values, how can I get it to allow me to select 1 and
gt; 3 or 1, 3, 5 and 6 all at once (like you would typically expect to do by
gt; holding down the CTRL key while selecting each value)?
gt;
gt; Your help will be much appreciated! :-)
gt; Nancy

You can do this with data validation and programming. There's a sample
file he

www.contextures.com/excelfiles.html

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

Nancy @ CHR wrote:
gt; Hello --
gt;
gt; We've got no problem in creating a list for a drop down box in Excel and
gt; assigning the list to a cell, etc. but how can you set it so that you can
gt; select multiple values? For example, if the drop down list includes
gt; 1,2,3,4,5,6 as possible values, how can I get it to allow me to select 1 and
gt; 3 or 1, 3, 5 and 6 all at once (like you would typically expect to do by
gt; holding down the CTRL key while selecting each value)?
gt;
gt; Your help will be much appreciated! :-)
gt; Nancy--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html