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
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
Last edited by bambino_32; 12-28-2009 at 09:50 AM.
The simples way is to do this at initialization
Kill the RowSource in the properties of the LB1.![]()
Please Login or Register to view this content.
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
Hi
Thank u for quick responce
I couldn't use 'em
Geing error mesags/
And when I press OK button nothing happens
See screenshot please
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
rwgrietveld
For example when table1 and table2 in listbox are selected, I need for the ranges B6:J19 and B23:J36 to be selected![]()
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.
Last edited by rwgrietveld; 12-28-2009 at 08:14 AM.
Thank u very much!!!!!!!!!!!!!!!!!!!!!!
And happy new year!!!!!!!!!!!!!!!!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks