Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,588
Default 10,000 element listbox possible? what about searching in it?

You have the initial array you loaded from the worksheet. To find the index
of a value just loop through the array and check whether the value matches
the current array position.

Mail me if you want help offline (making the obvious changes to my address).

Tim.

--
Tim Williams
Palo Alto, CA


"gguillermo" wrote in message
oups.com...
ok, i honestly gotta say that this time I am really lost. I dont
understand how I would be able to do that. LIke I mentioned, the reason
I need to do this is so that when I later export this info to be used
in a database, the position will be used as the key (i guess...i dont
know much about databases).
So the only way I can see I can do this is by keeping at least two
columns in each listbox with one of them being the index...
if you dont mind suggesting and explainng a little more what it is you
have in mind, I would really appreciate it.
thank you again!!!!!
-gguillermo



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
Searching, matching then searching another list based on the match A.S. Excel Discussion (Misc queries) 1 December 13th 06 05:08 AM
listbox B conditional of input in Listbox A Kim K Excel Discussion (Misc queries) 1 October 31st 06 08:27 PM
Multicolumn Listbox and ordinary listbox Ron_D Excel Programming 0 June 4th 04 08:56 PM
listbox.value not equal to listbox.list(listbox.listindex,0) ARB Excel Programming 0 October 22nd 03 12:46 AM
Is refreshing listbox rowsource in listbox click event possible? Jeremy Gollehon[_2_] Excel Programming 4 September 25th 03 06:45 PM


All times are GMT +1. The time now is 07:12 PM.

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"