populate listbox with multiple columns

[willsnake]

good day,

I am here again seeking help. Hoping for consideration..

I have this code that populates listbox, but it only has 1 column, I am hoping to find answer in adding column from selected data column.

Please Login or Register  to view this content.

Thank you...

[6StringJazzer]

Add red code. Update sheet name and column to suit. You must also define the list box properties to have two columns.

Please Login or Register  to view this content.

[willsnake]

Untitled.jpg

would there be a way to add another column just by changing the arrowed number from code?

[6StringJazzer]

Your code has no comments for what it is doing or why it is doing it and your post didn't explain it. If you explain what you're doing and attach a sample file I can dig into it.

[willsnake]

the code is from the attached excel. It was originally for populating combobox. And I modified it trying to apply in a listbox.. but my problem now is to display multiple columns in the listbox from identified columns from the worksheet data. and my worksheet data has about 18 columns. I only wish to populated selected worksheet data columns to be displayed in the listbox...

I don't fully know each code lines purpose.. from the original code, I just modify some figures.

[Norie]

Your code, as it is, only returns one column of data.

That column consists of unique values from column F on sheet 'PRData' where the value in column B matches the value in C11 on sheet 'PR'.

What other columns do you want to display in the listbox?

[willsnake]

c,e,g,h,i,k,l,m

[willsnake]

Your code, as it is, only returns one column of data.

That column consists of unique values from column F on sheet 'PRData' where the value in column B matches the value in C11 on sheet 'PR'.

What other columns do you want to display in the listbox?

good day,

Is my request possible?

[willsnake]

Good day,

Is there a way to populate listbox with multiple selected column based on vlookup typed in textbox?

Please need help...

Thnx...

[mehmetcik]

You are over complicating this. Load Columns C to D then hide the columns you do not need.

Please Login or Register  to view this content.

[willsnake]

I am sorry if I made it complicated.. I did type TEXTBOX instead of a certain cell in worksheet "PR"... sorry...

My aim is to populate a listbox with multiple columns, 2 - 4 columns.

The process in my worksheet is that, I open a userform then I type a certain value in textbox which is linked to a cell H12 from sheet "PR". Then in C11, there is a formula that transform the value in H12 to a certain format to be identified by vlookup in sheet "PRdata" in column B.

Then I was hoping to populate the listbox with data from sheet "PRdata", columns E-F, dependent from vlookup.
Or if possible extract from columns E-F, L, O, & Q.

Hope I was able to explain clearly...

Thank you...

[jindon]

The file you uploaded has only 1 shieet with 2 columns of data.

What do you expect us to do from such workbook?

[mehmetcik]

I will try again

Please Login or Register  to view this content.

[willsnake]

good day,

Sorry again... please ignore my attachment, it is the workbook that I refer when coding...

I would like to modify the code which will make it extract data to listbox with multiple columns... such data will be from selected columns from data sheet.

I only ask for an idea on what to modify in the code to work the way I wanted...

what part should I modify/add in this area?

for what I understand, this code

lets the code to extract data in 6th column or column F.
How will I modify it to extract data from selected columns before listing it the listbox?
How will I add columns E, G, & H data in the listbox?

[bakerman2]

Use Advanced Filter to filter your data to a temporary location.
Then you can use something like this

Please Login or Register  to view this content.

to fill your ListBox. The Array of numbers represent the columns you want visible in your ListBox.

[willsnake]

Good day,

Thank you sir... I had it working now with this code