Hi guys, I can't seem to find a answer to this question that is readily available, i have a list box on a user form i want to: For loop through a excel sheet when the first listbox changes. "ListBox1_Change()" - i've got that bit. It then goes through column A on sheet matches the value in listbox1. Then it offsets by 4 columns and puts the value of that column in a new entry of that listbox2. - It could have multiple values. if someone could point me to the right resource it would be great! Thanks

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Populate List Box With For Loop

Hi guys,

I can't seem to find a answer to this question that is readily available, i have a list box on a user form i want to:

For loop through a excel sheet when the first listbox changes. "ListBox1_Change()" - i've got that bit.
It then goes through column A on sheet matches the value in listbox1.
Then it offsets by 4 columns and puts the value of that column in a new entry of that listbox2. - It could have multiple values.

if someone could point me to the right resource it would be great!

Thanks