| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to add itemfrom a worksheet to a Listbox
I have a form with a 2 column listbox, and a worksheet with a two column
list. I want to add items from the worksheet list to the listbox based on specific conditions. For example: For Each c5 In dbeWS.Range("B2:B" & rngSAPlines).Cells If c5.Value = ufrmsiteInfo.cmbSiteID.Text And c5.Offset(0,1).Value ufrmsiteInfo.txtbox3.Text And c5.Offset(0, 4).Value = False Then ufrmsiteInfo.ListBox4.AddItem "worksheet row here" End If Next c5 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet and Listbox | Excel Programming | |||
| Not allow duplicates from listbox to Worksheet | Excel Programming | |||
| Help! Activate worksheet from a listbox | Excel Worksheet Functions | |||
| Using a VBA listbox to populate a worksheet | Excel Programming | |||
| listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
Threaded Mode
