I have a simple unbound single-select listbox with a Value list (not a table or query) and I want to be able to loop through the values and capture them in an array. Is it possible to loop through the values even when the items are not selected. Please include code snippet...
Thx in advance...
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Brewdog, seems like it would be loads more efficient to simply dimension based on the list size, before the loop. Rather than using the Redim Preserve.
Dim strArray() As String
Dim i As Integer
ReDim strArray(lstNames.ListCoun
For i = 0 To lstNames.ListCount - 1
strArray(i) = lstNames.ItemData(i)
Next i
Hi kenadelglass,
Any update on this question?
in an effort to clean up old open questions
your options are:
1. Accept a Comment As Answer (use the button next to the Expert's name).
2. Close the question if the information was not useful to you, but may help others. You must tell the
participants why you wish to do this, and allow for Expert response. This choice will include a refund
to you, and will move this question to our PAQ (Previously Asked Question) database. If you found information
outside this question thread, please add it.
3. Ask Community Support to help split points between participating experts, or just comment here with
details and we'll respond with the process.
4. Delete the question (if it has no potential value for others).
--> Post comments for expert of your intention to delete and why
--> You cannot delete a question with comments, special handling by a Moderator is required.
For special handling needs, please post a zero point question in the link below, include the question
QID/link. http://www.experts-exchang
Please click this Help Desk link for Member Guidelines, Member Agreement and the Question/Answer process:
Click you Member Profile to view your question history and keep them all current with updates as the
collaboration effort continues. http://www.experts-exchang
------------> EXPERTS: Please leave any comments regarding this question here on closing recommendations
if this item remains inactive another seven (7) days.
:O)Bruintje
Business Accounts
Answer for Membership
by: brewdogPosted on 1999-10-06 at 14:29:04ID: 2104806
I'm not sure what you want to do with them after you get them, so here's the snippet:
Dim strArray() As String
Dim i As Integer
For i = 0 To lstNames.ListCount - 1
ReDim Preserve strArray(i)
strArray(i) = lstNames.ItemData(i)
Next i
lstNames here is the name of your list box. Hope that helps . . .
brewdog