Add a multiselection list box to a spreadsheet
 

I need to add a multi selection list box to my spreadsheet.
I want to populate it with data from another sheet.
How do I do that?

Thanks

Add a multiselection list box to a spreadsheet
 

When I enter data into ListFillRange and move to another row entered data
disappears.


"sebastienm" wrote in message
...
Hi,

- Display the Control Toolbox toolbar: menu View Toolbars Control
Toolbox
- From the Control Toolbox toolbar, add a Listbox to the sheet
- Select the listbox and click on the Properties icon of the Control
Toolbox toolbar. The Properties window pops-up.
- Set the source data: for the ListFillRange property, say your source is
in sheet2 range A1:A10, set it to eg: 'sheet2'!A1:A10
- Still in the Properties window, go to the MultiSelect property and set
it either to Multi or Extended.
--
Regards,
Sébastien
PS: Rating a post as "the answer" helps searches and gives the answerer
credit for their contribution.


"Mark" wrote:

I need to add a multi selection list box to my spreadsheet.
I want to populate it with data from another sheet.
How do I do that?

Thanks