How to popoulate multioption listbox from another listbox using vlookup?

[Kiran2012]

Hi All,
I am working on a form. I am using listboxes with muti select option. Listbox2 is auto populated from first row of sheet i.e. Region.
If you select a region, the relevant Country should display in Listbox3. I done vlookup for this, but only first value is coming.
Please let me figure out the mistake. Also if we click same Region for a second time, the country names relevant to it should be removed.
Thanks in advance...

Please Login or Register  to view this content.

[Norie]

How is your data organised?

[Kiran2012]

Hi,

please find the sample form attached. Click on search button.