B
Bill
All,
I have done a fair amount of Excel VBA programming, but this is a new odd
behavior. I have a form with 3 listboxes. All 3 listboxes have a range as a
Rowsource. When the form opens they are all populated and display just fine.
I want an item selected in the first listbox to force the same selection
(i.e. listindex) in the other 2 listboxes. In the listbox1_Click()
subroutine I put the following code:
listbox2.ListIndex = listbox1.ListIndex
listbox3.ListIndex = listbox1.ListIndex
v1 = listbox1.Value (or .Text)
v2 = listbox2.Value (or .Text)
v3 = listbox3.Value (or .Text)
v1 and v2 have the right stuff but v3 = ""
Any ideas?
TIA,
Bill
I have done a fair amount of Excel VBA programming, but this is a new odd
behavior. I have a form with 3 listboxes. All 3 listboxes have a range as a
Rowsource. When the form opens they are all populated and display just fine.
I want an item selected in the first listbox to force the same selection
(i.e. listindex) in the other 2 listboxes. In the listbox1_Click()
subroutine I put the following code:
listbox2.ListIndex = listbox1.ListIndex
listbox3.ListIndex = listbox1.ListIndex
v1 = listbox1.Value (or .Text)
v2 = listbox2.Value (or .Text)
v3 = listbox3.Value (or .Text)
v1 and v2 have the right stuff but v3 = ""
Any ideas?
TIA,
Bill