Add Listbox Values to an Array

[t0m46]

Hey all,

I have two listboxes the user selects the value from one listbox and puts it to the next listbox. i then want to run a code to look through the second listbox and add each item in the listbox to an array.

the code i have works if the user clicks on the first item in the listbox, but it doesnt work if they dont. i want it to work if the user hasnt clicked on the first item, i just want it to look through and get all values.

Please Login or Register  to view this content.

I though that the ListBox2.ListIndex = COUNT would select an item and then would get the value from it but it doesnt seam to work.

Thanks

[romperstomper]

Please Login or Register  to view this content.

[t0m46]

Hey Thanks,

Is there now a way to Msgbox each Item from the Listbox?

I have Tried

Please Login or Register  to view this content.

and Msg

Please Login or Register  to view this content.

but it doesnt display anything

Thansk

[t0m46]

Hey,

Not to Worry, i dont to Msgbox it now.

Thanks That was anoyingly simple to get the items into an array.

[t0m46]

Hey,

The Array isnt working with the list box with what i want to do.

i want to get the values from the listbox, assaign to an array for each value in the listbox then filter them.

Please Login or Register  to view this content.

It breaks on the Filter part and comes up with Error Runtime Error 13, Type MisMatch

I added a Watch and it looks like the values arent getting assigned to the array so it cant filter by anything.

Thanks

[romperstomper]

NARY is an array, so you don't use Array(NARY), you just use NARY. I assume you are using 2007 not 2003 since 2003 doesn't accept arrays as filter criteria.

[t0m46]

Have Tried that and it still uses the same error.

I am using 2007 and i have another filter that works with an array

[romperstomper]

Ah, I guess you are using AddItem to populate the listbox? In that case use:

Please Login or Register  to view this content.

[t0m46]

Hey,

Yer sorry I should of said I was using .additem.

That works now anyway.

Thanks for all your help

[romperstomper]

To be honest, I should have realised that based on your initial description!