lcfc2kotmail
11-26-2007, 05:07 PM
Hi, I have a quick question im familair with coding VBA within excel however I am trying to create a program for my project and require any tips for the following
I have an array of data 30 colums byt say 20 rows to make this simple. Each column represents data from a company and I would like to analyse these.
What I would want to know if there is a way I can have a list box that can have the names of these 30 companies and each of the companies once selected is linked to that row of data. Once the user select the number of companies they want, this data is then read into a multidemntional array say M (r , c) , where r is rows and c is columns.
This will give me a flexible option of the software allowing the user to select companies rather than having to use a fixed array with that data stored in.
e.g.
company 1 company 2 company 3
1 3 4
3 4 6
6 1 3
This data would be in say sheet 1, my program in sheet 2, and would contain a list box: Company 1
Company 2
Company 3
It will allow the user to select multiple options, and for each company selected, it will read in the range of data for that select company into an array. then my program can do the rest based on the data from this array - at the moment it is using a fixed array from all 3 companies.
Many Thanks
I have an array of data 30 colums byt say 20 rows to make this simple. Each column represents data from a company and I would like to analyse these.
What I would want to know if there is a way I can have a list box that can have the names of these 30 companies and each of the companies once selected is linked to that row of data. Once the user select the number of companies they want, this data is then read into a multidemntional array say M (r , c) , where r is rows and c is columns.
This will give me a flexible option of the software allowing the user to select companies rather than having to use a fixed array with that data stored in.
e.g.
company 1 company 2 company 3
1 3 4
3 4 6
6 1 3
This data would be in say sheet 1, my program in sheet 2, and would contain a list box: Company 1
Company 2
Company 3
It will allow the user to select multiple options, and for each company selected, it will read in the range of data for that select company into an array. then my program can do the rest based on the data from this array - at the moment it is using a fixed array from all 3 companies.
Many Thanks