Display listbox items in coulmn no2 bases on coulmn no 1

[sbvaram]

Dear All,

I have a userform of listbox , in this listbox i need a display Customers list in Listbox1.column no. 2 based on listbox1.column no.1 Area Name only

following Listbox output result required using vba code.

listbox-001-001.jpg


Kindly help.

Thank you all ..

[jindon]

Replace UserForm_Initialize event code with

Please Login or Register  to view this content.

[sintek]

Another Option...If you don't mind your data sorted...Can always refresh back to original state...

Please Login or Register  to view this content.

[sbvaram]

Perfectly work ..

Thank you Jindon Sir for your very very very fast reply
& also Thank you sintek sir both is working correctly


small request sir, can is poosible for column no.1 Area name & column no. 2 party name is alphabet sorting..

[jindon]

Change to

Please Login or Register  to view this content.

Edit;
Didn't think Col.1 as well... so fixed

[sintek]

can is poosible for column no.1 Area name & column no. 2 party name is alphabet sorting.

Please Login or Register  to view this content.

[sbvaram]

Excellent .......

Thank you jindon Sir & Sintek sir..
Thank you very much

[sintek]

.........................
Thanks.png