ListBox question
Hi,
On the ListBox1_Change event you call a sub "RefreshListBox2", so that the
selection of ListBox1 can take effect. Something like this.
Private Sub ListBox1_Change()
RefreshListBox2
End Sub
Private Sub RefreshListBox2()
Me.ListBox2.Clear
'write the code to put in the filtred data
'remember you have to take care of all
'ListBox1 posibilities here..
End Sub
Hopes it helps
Flemming
"LearningExcel" wrote in message
...
I am using a Forms toolbar List Box. Based on the value selected in the
list
box I would like to see certain filtered items in another list box.
For instance - ListBox1 - has items - A, B, C, so on.
If I select B in ListBox1 then in ListBox2 only items starting with B
should
show up.
Is it possible?
|