Sorting ListBox Values into a Separate ListBox

**Jaredm577** · 03-31-2019, 10:18 PM

Hi,

I am attempting to creating a shipping optimisation program, and a step along the way is extracting values from a ListBox (ListBox2) that are below a certain value (2300).
I cant seem to be able to successfully run a sub that checks each value in the second column of ListBox2, and if this value is below 2300, it adds the entire row to a separate ListBox (ListBox3).
I have included the code below and I'm sorry in advance, I'm sure this is a really simple question!

Please Login or Register  to view this content.

**bakerman2** · 03-31-2019, 10:30 PM

The second column in a ListBox has index 1 because indexes for Rows and Columns in a ListBox start at 0.

Also you will have to loop through each column of a record in listbox2 to add it's value to listbox3

Sorting ListBox Values into a Separate ListBox

LinkBack

Thread Tools

Rate This Thread

Display

Sorting ListBox Values into a Separate ListBox

Re: Sorting ListBox Values into a Separate ListBox

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Show unique values in listbox and activate related cell if i select value in Listbox

vba excel - adding listbox values from listbox

Show dynamic values at listbox depending value selected another listbox

[SOLVED] if anything in listbox select first item, if listbox empty do nothing (listbox in userform

[SOLVED] How do I populate a listbox with a list excluding values found in another listbox?

Based on listbox values, go to a URL in webbrowser containing those listbox values

Listbox to Listbox, no duplicates & submitting same UserForm data for each Listbox entry.

Bookmarks

Bookmarks

Posting Permissions