Populate multicolumn listbox

[Petter120]

Hi

i use this code to populate a list box from worksheet "Data"

The problem i have is that i want to populate both column A and B to the listbox and
with this code i only get it to populate from column A, can anyone help me with what
i have to add to make it populate both columns in the the listbox ?

Please Login or Register  to view this content.

Right now i using this code and i works, exept it populates the active sheet i have open in excel i want to have another sheet open when i open the userform.

Please Login or Register  to view this content.

Petter

[Andy Pope]

Those 2 code do different things. The first will skip empty cells between row 1 and the end row. The second uses all cells between row 1 and end row.

2 columns

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Petter120]

Ok but it seems to work fine now

Please Login or Register  to view this content.

[Andy Pope]

You will notice I added the . (period) before the Range property as you use the With command.

Without the period the range would reference the active sheet rather than the sheet specified in the With