Hi there,
I'm trying to populate a Listbox "listbox3" with two columns on a worksheet. These columns aren't set next to one another, therefore I cannot just assign a rowsource of "A:B" etc.. it would instead need to be "D" and "F".
I have started a piece of code (below) however not sure if I'm going about it the right way. Any advice would be greatly appreciated.
Please Login or Register to view this content.
Last edited by RayJay01; 12-27-2013 at 04:51 PM.
It is simplest to assign the three columns to the list box and make the second column width 0. You may also create an array from the two columns and assign it to the List property of the Listbox but I do not see benefit over simply using three columns.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
Sorry to be a pain, but could you give me an example of what you mean please?
Example of which option?
I'll go with the Array please. Only because I think it may help to learn how best to use an array, I'm sure this will come in handy a lot. I've tried to create a version below, but it still doesn't work. Loads a two column listbox, just no data inside it... =\
Please Login or Register to view this content.
Try this.
Please Login or Register to view this content.
If posting code please use code tags, see here.
Norie has given example for three columns with one hidden. If you wish array from two columns you may use code like this:
Please Login or Register to view this content.
Izandol
I don't think you need the row argument, as far as I know if you leave it out INDEX will return the entire column(s) from the reference range.
Norie
If you pass array for third argument you must use array for second - using 0 or omitting does not work unfortunately.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks