Add a multiselection list box to a spreadsheet

[Guest]

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

 

[Mark Goldin]

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

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.