Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Weird Do...Until behavior... | Excel Programming | |||
weird macro behavior | Excel Discussion (Misc queries) | |||
Weird clipboard behavior | Excel Programming | |||
Weird Sorting Behavior | Excel Programming | |||
Weird behavior of VLOOKUP | Excel Programming |