Populating a ComboBox from two columns (as list not beside each other)?

Hi all,

I have a table: ALL Service Packs with 2 columns: Service Packs - A Status and Service Packs - B Status.

I'm trying to make a combobox which is populated with All of our possible service packs A and B as well, but I need to keep this table as it is, as the formulas look into the different columns for A and B statuses..

but this code:

Please Login or Register  to view this content.

only returns the first column not both of them...

Can someone help please?

Try:

Please Login or Register  to view this content.

Perhaps:-

Please Login or Register  to view this content.

no those both put the 2 columns into the same field.. like this:

Attachment 618993

Blue is A status - Orange is B status and I can only choose the A status ones.. the B-s just show up beside.. I need to be able to select all the packs regardless of the status or which column they are in.

Both columns are visible - see attachment.

No I need it like A, B ,C ,D, E, 100, 200, 300, 400, 500 all below each other, so I can choose just A or just 500, Sorry I'm not the best at explaining.

Attach an example with some false data and an example of the appearance of the list box after loading data into it.
Link to your attachment not working.

I have added a how I would like the combo box to look like - macro, only the table that it is based on is not right, as I would need the table to look like as in A and B columns.

I was thinking maybe with an array but I'm rubbish in arrays and I couldn't get it to work..

Oh wow.. that seems so complicated :/ I wouldn't be able to fix it if something went wrong..

Try this way:

Please Login or Register  to view this content.

Oh I see what you did there I'm gonna give this a go.. Thanks!

I see you can do arrays tho.. would something like this not be possible? I tried that below but I think I got a mismatch when I tried to debug.print it, so I sort of gave up on it.. or is that still a 2D array thats why its not working?

Please Login or Register  to view this content.

You've made it even more complicated because you've just made a "matryoshka doll", you put two areas (arrays) into the another area/array (variable myarray), like two small boxes into another greater box.

Exemplary "matryoshka solution", one of many:

Please Login or Register  to view this content.

What kind of solution are you looking for ? You already have 3 at this moment ...

The subject of your post no. 1 is completely different than your final post/conclusion.

Sorry I was being difficult Thank you for all your help!