Select Multiple Tables With Listbox

Hi
Is it possible to select multiple tables with listbox. If not, please privide me another way to do that.
please see attached and u'll understant what I need to fo.

Happy New Year

The simples way is to do this at initialization

Please Login or Register  to view this content.

Kill the RowSource in the properties of the LB1.

Hi Ricardo. trying this out to learn ... I get

Run time error '1004':
Method 'range' of object '_Global' failed.

whatever that means. (I did delete the RowSource property for ListBox1)

I'm not sure what your code is supposed to be doing, could you explain?

As far as I interpret the OP's question, they want to tick the boxes in the list box, then hit OK and as a result have the tables in the sheet selected.

Is that how you read this, too?

cheers

The following code is straight forward. Although I do not feel this is my best solution, I'll post it nevertheless.

Assumptions:
All ranges are of the same size.
Als ranges have an equal offset (17 rows in between)
Table1 refers to =Sheet1!$B$6:$J$19

Please Login or Register  to view this content.