Need VBA code to make One listbox show same selected values on secondary listbox

[atf32]

Need help. On one worksheet I have one listbox that holds several different country names. This listbox allows me to select multiple countries at once. On another worksheet, I have another listbox that holds the same list of counties as in the first listbox. I would like to set it up so that when I select the countries in one of the listbox's, the same selected items will show up on the other listbox as highlighted, and vice versa, as if I selected the same countries on the other listbox.

 

[Rick Rothstein]

Where did the ListBox come from... the Forms toolbar or the (ActiveX) Control Toolbox toolbar?

 

[atf32]

ActiveX Toolbar.

 

[Rick Rothstein]

This event code appears to keep ListBox2 at the same selections as ListBox1...

Private Sub ListBox1_Change()
  Dim X As Long
  With Worksheets("Sheet1")
    For X = 0 To .ListBox1.ListCount - 1
      .ListBox2.Selected(X) = .ListBox1.Selected(X)
    Next
  End With
End Sub

 

[atf32]

Great, thanks for the help.