Load excel range into multi dimensional array

R

Rishi Dhupar

Hi,

I am trying to figure out how to load my entire used area of an excel
sheet into a multi dimensional array. I cannot seem to find anything
close to doing this. Does anyone know how to do this?

Thanks a lot,

RishiD
 
R

Rishi Dhupar

Objective here is I have a list box, that is being filled with only 3-4
importants columns, then I want to be able to click on each item, and
have the rest of the data displayed in text boxes below the list box.
Loading the data into a MD array seems most logical right? If not is
there another method to do this, just need to figure out how I can
relate the listboxindex to the data I want from the worksheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting multi-dimensional array 1
Multi-Dimensional Array 17
Multi-Dimensional Array Procedures 2
append multiple worksheets data into a single multi-dimensional array 4
Returning an array from a multi-dimensional array 2
Multi Dimensional Array 4
Multi Dimensional Array 11
Populate a multi-dimensional array from Ranges 7

Top