ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Listbox Slider control (https://www.excelbanter.com/excel-programming/343145-listbox-slider-control.html)

MikeM

Listbox Slider control
 
I'm using a listbox to select states and cities. [I'm not using the ActiveX
listbox because it needs to work in both PC and Mac environments.] Selecting
a state in one listbox populates the second (city) listbox, which has a
different size depending on the state. My problem is this:

If the last city I selected was Yuma Arizona, when I switch to Arkansas I
want the (alphabetized) city first up to be Alma -- which I can control by
putting a 1 in the cell link. But the slider on the right of the listbox is
halfway down the listbox instead of sitting up at the top.

How can I force the slider to the top?


All times are GMT +1. The time now is 12:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com