I am using excel 2010. I have two listbox controls in my sheet. I need to select or highlight the multi select listbox items in the second list box based on the item selection of first listbox(Single select). The listbox i am using is activex controls.

So in the click event of the listbox control. I am doing the VBA coding. But facing issues when selecting the items in the listbox.

Any sample code or examples on this is appreciated.