| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
command button that copies and pastes from one list box to another
I inserted the below code to accomplish the below. Why do I get an error for
the i ? Private Sub CommandButton1_Click() If ListBox2.ListIndex = -1 Then Exit Sub If Not cbDuplicates Then 'See if item already existss For i = 0 To ListBox2.ListCount - 1 If ListBox2.Value = ListBox3.List(i) Then Beep Exit Sub End If Next i End If ListBox3.AddItem ListBox2.Value End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| clicking on a button copies the choice *(VBA) | Excel Discussion (Misc queries) | |||
| Some formulas don't track copies, pastes, fill right, fill down | Excel Discussion (Misc queries) | |||
| Where is a list of Command Button uses? | Excel Discussion (Misc queries) | |||
| A Macro that Copies from Excel & Pastes into a webpage | Excel Discussion (Misc queries) | |||
| Copies 02/22/2005, Pastes 02/21/2001 | Excel Worksheet Functions | |||
Threaded Mode
