Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multi-Dimensional Array Let & Get Trip[_3_] Excel Programming 0 September 21st 05 08:41 PM
UBound of multi-dimensional array? Jake Marx[_3_] Excel Programming 0 August 16th 05 06:34 PM
Transferring part of a multi-dimensional array to a range in VBA Bob J.[_3_] Excel Programming 1 July 27th 05 03:38 PM
Viewing Multi dimensional array Codea Excel Programming 1 August 5th 04 01:30 PM
Problem with Multi-Dimensional Array Kirk[_2_] Excel Programming 2 August 26th 03 03:31 PM


All times are GMT +1. The time now is 11:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"