Getting values from list box

[ChrisMattock]

Good afternoon all, I have been having fun with listboxes all day and have one last(!) problem.

I need to get all of the values from a listbox and place them in variables, the trouble is I do not know how many items there will be in the list box, no more than 20 probably. Can you help? Thanks in advance! Rep for all who help!

[dominicb]

Good evening ChrisMattock

Using the ListCount property should do the trick :

Please Login or Register  to view this content.

HTH

DominicB

[ChrisMattock]

Good evening Dominicb!

Would you be so kind as to elaborate on that, I understand that supplies me with the number of values, but then how do I assign each value to a variable? If I even need to that is.

In terms of output I am looking for a list down however many rows are necessary in an excel worksheet.

[dominicb]

Hi ChrisMattock

Would you be so kind as to elaborate on that, I understand that supplies me with the number of values, but then how do I assign each value to a variable? If I even need to that is.

The code below will dump the contents of ListXox1 into an array (a). The second block of code you don't need - it's just proving that all the items are there and shows you how to access them :

Please Login or Register  to view this content.

HTH

DominicB

[Kenneth Hobson]

One has to be careful to be sure that you know if you are working with a 0 based array. Of course the listbox is 0 based. It is usually a matter of +/- 1 which can be done in the loop counter or the list index and index for the array.

Here is my example. Make a() Public if you need it for later in the code.

Please Login or Register  to view this content.

[ChrisMattock]

Hey guys, thanks for both of your help very much appreciated! SOLVED! +rep to you both.