Fill listbox with 2 different ranges

**meabrams** · 10-14-2018, 07:54 AM

Looking for a way to fill a listbox with 2 ranges separate ranges. Each Range has 2 columns in it and the Listbox needs to stay as 2 columns

**BadlySpelledBuoy** · 10-14-2018, 08:18 AM

Is this a listbox on a userform or on a worksheet?

BSB

**meabrams** · 10-14-2018, 08:20 AM

Userform information is being pulled from different wokbook

**meabrams** · 10-14-2018, 08:25 AM

able to pull one range from the other workbook but still unable to get the data from the second range to add to the list

**meabrams** · 10-14-2018, 06:37 PM

heres my current failed attempt to get this working trying to use 2 different arrays joined into one.. it fails when it tries to add to the listbox

Please Login or Register  to view this content.

**meabrams** · 10-14-2018, 10:33 PM

The current working work around that I have is:

in module

Please Login or Register  to view this content.

in Userform

Please Login or Register  to view this content.

I would really like to get to where I am having to temporarily store the data on the master sheet at all. Any help to appreciated

Re: Fill listbox with 2 different ranges