Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 30
Default Passing a list to an array

Just curious to know if it is possible to convert a listbox of values
to an array, such as:

Dim arrA as variant
with me.listbox1
arrA = array(.list)
end with

Seems like functionality that would make sense.
It's a pain to do the for i = 0 to .listcount - 1 thing to
create an array.

TIA,
Matt

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
Passing Byte array to DLL Tom Excel Programming 2 May 4th 06 04:23 PM
Trouble Passing An Array Kevin O'Neill[_2_] Excel Programming 3 January 6th 06 06:25 PM
Need help passing an array as an argument blc[_3_] Excel Programming 3 August 4th 04 10:35 PM
PASSING an array to a sub in VBA Wombat[_2_] Excel Programming 2 November 30th 03 11:48 AM
Passing array to a function GB[_3_] Excel Programming 3 October 21st 03 09:59 AM


All times are GMT +1. The time now is 12:58 AM.

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

About Us

"It's about Microsoft Excel"