MULTIPLE COLUMNS IN LISTBOX

[Prabhu9teen]

Hi Everyone,

I have managed to find a vba which suites my requirement, also made few changes to match my exact requirement.

Need your advise to add a third column next to the below result box.

the below result box showing

List 1: Country - This is done!
List 2: Zip - This is done!
List 3: Need to add Type ("Column 3") - Need help to display this next to column 2.

also kindly advice how to fit the contents in the result list box, from the below screenshot you can able to see the country is partially hidden! thanks




Thanks,
Prabhuraj

 

[Khalid NGO]

Hi,

I am not an expert in VBA, just sharing my attempt.

You can Set width to your need:


I have include next column with minor change in your code:
Sub FindAllMatches()



See the attached if it meets your need.

Regards,

 

[Prabhu9teen]

Great thanks Khalid! Another new learning for me..
Have a great day

 

[Khalid NGO]

Great thanks Khalid! Another new learning for me..
Have a great day

Glad it worked for you...
Thanks for the feedback.

 

[Prabhu9teen]

Hi Khalid,
Adding to that, i'm trying to add the selected fields to next sheet, but i'm successful to some extend only, first column is getting exported to next sheet but not all...

Attached copy of the revised file for your easy reference..

Appreciate your great help on this!






Thanks,
Prabhuraj

 

[Khalid NGO]

Sorry Raj,
So far no luck to understand.
Hope someone will update.

Regards,