listbox code

[dadas]

list box code....


i have 2 list boxes...list91 & List93
I want to have it so if u select a the first item in list91 it automatically selects the first item in list93, if u select the second item it selects the 2nd item, if u select the third...u get the point...is there vba code i can use for this?

also is there a way to make it so u can scroll to the right in a list box....all my items are small exept for a few, and i dont want to have a giant list box so ide liek to give the option to scroll to the side to read certain ones. THANKKKSSSS

[June7]

Try:
N = Me.Listbox1.SelectedIndex
Me.Listbox2.Selected(N) = True

Apparently the horizontal scroll bar will automatically show if the listbox is set for multi-column. Even then not able to scroll far enough to see all of last column. Never thought much about this. Always sized listboxes to fit and don't use them much anyway. Not seeing horizontal scroll bar with a single column.

[dadas]

thanks dude, u helped alot the only thing i changed is i used the listindex. because selectedindex doesnt work in access...thanks!!!

[June7]

Glad you figured it out. Sorry I grabbed the wrong property from my search.