Populate multicolumn listbox

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

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.

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