Load excel range into multi dimensional array
 

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

Load excel range into multi dimensional array
 

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.