W
wpllc2004
Hello
Can someone please help me with a problem that I've with Userforms and
Listboxes?
The problem is that I've a multicolumn listbox loaded in a userform
(multipage control) and depending on option buttons (or other
controls) I would like to select some rows so I can manipulate them in
the next tab of the multipage control.
My code for a command button that selects all the rows is the
following:
Private Sub cbAll_Click()
Dim i As Integer
For i = 0 To lbSales.ListCount - 1
lbSales.Selected(i) = True
Next i
End Sub
However I would like to select all the rows that have a particular
value (ie ">1000" in column 4) in one of the columns of the listbox.
Can anyone help me?
Many thanks
Can someone please help me with a problem that I've with Userforms and
Listboxes?
The problem is that I've a multicolumn listbox loaded in a userform
(multipage control) and depending on option buttons (or other
controls) I would like to select some rows so I can manipulate them in
the next tab of the multipage control.
My code for a command button that selects all the rows is the
following:
Private Sub cbAll_Click()
Dim i As Integer
For i = 0 To lbSales.ListCount - 1
lbSales.Selected(i) = True
Next i
End Sub
However I would like to select all the rows that have a particular
value (ie ">1000" in column 4) in one of the columns of the listbox.
Can anyone help me?
Many thanks