multi-select listbox positioning

  • Thread starter Thread starter chuck
  • Start date Start date
C

chuck

I have a multi-select listbox containing a few hundred people names.
There are situations where the app requires only a single name be
selected in the lbx, and multi-select can't be changed in VBA code.

I have an option group with 27 buttons labeled A-Z and *. Clicking the
button deselects everything in the lbx, then selects the 1st row with
lastname beginning with that letter or greater; clicking * clears all
entries without selecting anything.

The problem is, with hundred of rows, it is possible (likely) that the
selected letter will NOT be visible in the lbx, and a multi-select lbx
is NOT automatically positioned to the selected item - thus the user
can't tell that his/her item has actually been selected except by
manually scrolling down.

Is there a way to programmatically position a multi-select lbx so that a
spefcific row (e.g., the selected one) is in the visible area??

Thanks in advance for any help.

Chuck
 
Back
Top