Adding Items to List box from cell range but skipping items duplicated in another range

Hi

I'm new to this so please so sorry if this is a stupid question.

I have a userform with 2 list boxes in with buttons that move items between the boxes.
Driver List.PNG

Items are added to the list box on the right from one cell range and items items are added to the left list box from a different range. However, when adding items to the list box on the left I want it to miss out any items that appear in both ranges. so far I have

Private Sub UserForm_Initialize()

Please Login or Register  to view this content.

I tired using the removeitem function in the second for each loop but kept getting errors and I can't figure out how to use the listindex to remove items from the list either.

Any help would be greatly appreciated.

Cheers

that's great, thanks so much for your help . I ended up using a combination of my original and yours to avoid leaving blank lines in the list box. Works great now. Thanks again.

Please Login or Register  to view this content.