T
tonia_b3
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?
within the cell. Is there a way to do that?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Doug Kanter
tonia_b3 said: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.
T
tonia_b3
I just tried and it didn't work. Thanks for the suggestion.
D
Dave Peterson
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
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