Return the values from the 2nd Column in a Listbox

**Jonathan78** · 09-01-2016, 10:25 AM

Hello All,

The following code fills a range with values from the first column of ListBox1.
I'd like however to fill the range with values from the 2nd column.
All help is welcome!

Please Login or Register  to view this content.

**davesexcel** · 09-01-2016, 10:36 AM

Probably,

Please Login or Register  to view this content.

**Neil_** · 09-01-2016, 10:37 AM

ListBox1.List(n - 1, 1). Column index begins at zero.

**YasserKhalil** · 09-01-2016, 10:48 AM

Just add 1 to the second part

Please Login or Register  to view this content.

**Jonathan78** · 09-01-2016, 04:28 PM

Thanks guys, that solved it!

**YasserKhalil** · 09-01-2016, 04:35 PM

You're welcome. Thanks for the feedback and for the rep points

Return the values from the 2nd Column in a Listbox

LinkBack

Thread Tools

Rate This Thread

Display

Return the values from the 2nd Column in a Listbox

Re: Return the values from the 2nd Column in a Listbox

Re: Return the values from the 2nd Column in a Listbox

Re: Return the values from the 2nd Column in a Listbox

Re: Return the values from the 2nd Column in a Listbox

Re: Return the values from the 2nd Column in a Listbox

Thread Information

Users Browsing this Thread

Similar Threads

Adding multiple column values using listbox

[SOLVED] Search value enterred in TextBox2 in WS and return values in ListBox

[SOLVED] Listbox change event to return two values to different cells

Code not to add duplicate values to my 2 column-listbox

Search Values in a Column and List them in a ListBox

[SOLVED] returning values multi column listbox

[SOLVED] How do I return the unique entries from a column to a listbox

Bookmarks

Bookmarks

Posting Permissions