Help to show multiple columns in a listbox

[ExcelFailure]

Hello,

I need help to change the below code so that it shows 2 columns of data in the listbox as opposed to just 1 which is what it does currently. Can anyone help?

Please Login or Register  to view this content.

[Parth007]

Please attach a sample excel sheet if you have..

[Norie]

The first thing you need to do is change the ColumnCount property of the listbox to 2.

You'll then have 2 columns in the listbox, but we would need more information to help you populate them.

[ExcelFailure]

Sorry that was the code for the wrong userform! The userform I am talking about is less complicated I think

Code is below. I have changed the ColumnCount to 2, the data that needs to go in there is simply from a table column

Please Login or Register  to view this content.

[Norie]

Which column does the data for the second column in the listbox come from?

[ExcelFailure]

It's in the same PivotTable. The second column in the same Pivot Table

[ExcelFailure]

Anyone got any ideas on this please?

[Norie]

You don't refer to a pivot table in the posted code so it's kind of hard to work out how to refer to the second column of a pivot table.

[ExcelFailure]

No sorry the pivot table column has been made into a named range, which is the dd_codes that the code refers to. There might have been an easier way to do it.

[Norie]

If the named range 'dd_codes' refers to the first column of the pivot table and you want to show the first two columns in the listbox this might work.

Please Login or Register  to view this content.

[ExcelFailure]

OK is that to replace any code or just to add onto the end?

[Norie]

It replaces this code.

Please Login or Register  to view this content.

[ExcelFailure]

Thanks, just tried that and it says invalid use of property?

[Norie]

What exactly did you try?

[ExcelFailure]

Please Login or Register  to view this content.

[Norie]

Oops, should be this.

Please Login or Register  to view this content.

[romperstomper]

It's

Please Login or Register  to view this content.

not just

Please Login or Register  to view this content.

[ExcelFailure]

Excellent, that has sorted it.

Many thanks both of you.