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?

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?

Thank you.
Is it possible to achieve this without writing VBA code?

"Flemming Dahl" wrote:

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?