Thread: list box
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joe[_17_] Joe[_17_] is offline
external usenet poster
 
Posts: 5
Default list box

I would like the code to insert a name into a list box if
the check box is checked and remove it if it is
deselected. How could I do this.

thanks in advance.

Joe

Private Sub CheckBox1_Click()


If count Mod 2 = 0 Then
List.AddItem "Manning, Joe"
Else
List.RemoveItem (List.ListCount)
End If
count = count + 1


End Sub