I am trying to set up an alert (msgbox) on a userform.
If the user clicks on a value in Listbox1, AND the value is not listed in
Listbox2, then the value is added to the Listbox2 list.
1). If the value in Listbox1 is already added to Listbox2 i want a msgbox to
state that is already there.
2). I also want a value removed from Listbox2 if it is selected, how do i
Remove an item from a listbox when clicked on ?


Thus far i have:

Private Sub ListBox1_Click()
' Need to ensure only unique values are added to Listbox2 by a msgbox Alert
when a duplicate value is clicked on in Listbox1
ListBox2.AddItem ListBox1.Value
End Sub


Private Sub ListBox2_Click()
ListBox2.Removeitem ' This gives me a error though !
End Sub

--
Corey ....
The Silliest Question is generally
the one i forgot to ask.