Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
list box
Try using the Checkbox1_AfterUpdate() event with the
following logic: Private Sub cbxEnablePipette2_AfterUpdate() If Checkbox1.value = true then 'add the item Else 'remove the item End If End Sub Hope that helps... -----Original Message----- 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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
list box
Hi Joe,
Not sure if this is what you want, but try this... not tested... ------------------------------ Private Sub CheckBox1_Click() If CheckBox1 = True Then ListBox1.AddItem "Manning, Joe" Else ListBox1.RemoveItem "Manning, Joe" End If End Sub -------------------------------- Hope this helps... Chong Moua -----Original Message----- 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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
list box
I get an error when i try to use
listbox1.removeitem "manning, joe" any other suggestions? Thanks Joe -----Original Message----- Hi Joe, Not sure if this is what you want, but try this... not tested... ------------------------------ Private Sub CheckBox1_Click() If CheckBox1 = True Then ListBox1.AddItem "Manning, Joe" Else ListBox1.RemoveItem "Manning, Joe" End If End Sub -------------------------------- Hope this helps... Chong Moua -----Original Message----- 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 . . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
list box
Joe, this should work...
---------------------- Private Sub CheckBox1_Click() If CheckBox1 = True Then ListBox1.AddItem "Manning, Joe", 1 Else ListBox1.RemoveItem 1 End If End Sub ---------------------- Chong Moua -----Original Message----- I get an error when i try to use listbox1.removeitem "manning, joe" any other suggestions? Thanks Joe -----Original Message----- Hi Joe, Not sure if this is what you want, but try this... not tested... ------------------------------ Private Sub CheckBox1_Click() If CheckBox1 = True Then ListBox1.AddItem "Manning, Joe" Else ListBox1.RemoveItem "Manning, Joe" End If End Sub -------------------------------- Hope this helps... Chong Moua -----Original Message----- 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 . . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing List A to List B and add what's missing from List B | Excel Discussion (Misc queries) | |||
create new list from list A, but with exclusions from a list B | Excel Worksheet Functions | |||
validation list--list depends on the selection of first list | New Users to Excel | |||
list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions |