I created a list box, and want to allow a user to select multiple items
within the cell. Is there a way to do that?

"tonia_b3" wrote in message
...
I created a list box, and want to allow a user to select multiple items
within the cell. Is there a way to do that?

This works on some web sites - haven't tried it in Excel: Hold down the CTRL
key while clicking more than one list box choice. Can't start Excel at the
moment to find out. Please report the results.

I just tried and it didn't work. Thanks for the suggestion.

"Doug Kanter" wrote:


"tonia_b3" wrote in message
...
I created a list box, and want to allow a user to select multiple items
within the cell. Is there a way to do that?

This works on some web sites - haven't tried it in Excel: Hold down the CTRL
key while clicking more than one list box choice. Can't start Excel at the
moment to find out. Please report the results.

Is the listbox on a worksheet?

If yes, is the listbox from the Forms toolbar?

Then rightclick on the listbox and choose: format control
Then on the Control tab, choose Multi in the selection type frame.

If the listbox is from the control toolbox toolbar, then
go into design mode (another icon on that control toolbox toolbar
Rightclick on the listbox, choose properties
Change the .multiselect property to 1 - fmMultiSelectMulti



tonia_b3 wrote:

I created a list box, and want to allow a user to select multiple items
within the cell. Is there a way to do that?

--

Dave Peterson