OccasionalGeek
New Member
- Joined
- Mar 1, 2012
- Messages
- 12
I'm using Excel 2010. I'm also a first-time poster on this forum, so I may amend or post clarification, later, if needed. And I welcome comments on forum protocol or requirements.
I use VBA code extensively in the application. There is a "trigger" (on the down arrow of the Combo) to a subroutine that repopulates the fill list range and resizes the range depending on the number of items found (it contains directory listings for specified file names). That routine resizes/creates the fill list range name each time it runs.
When I create an ActiveX Combo linked to a cell on the same sheet and using a range for the "Fill List" that is on the same sheet, it works fine. Sliders appear on the drop down list no problem.
However, when I "save>close>open" the workbook (an .xlsm file, and macros are enabled), the sliders aren't there, even if the range contains more items than can fit on the size of the drop down list. (I'm not sure it is the close/open process that causes the problem - haven't uniquely identified the exact action that causes the slider to disappear.)
If I re-create the dropdown, it works fine, again, but then loses the slider again at some point I can't clearly identify, yet.
I've Googled "Excel Combo missing slider" and all sorts of related key words, but no joy on finding anyone reporting the same problem.
Anyone have similar experience, or can you offer a possible suggestion? I've experimented with most of the remotely connected properties of the Combo object, but can't find a solution.
Thanks.
I use VBA code extensively in the application. There is a "trigger" (on the down arrow of the Combo) to a subroutine that repopulates the fill list range and resizes the range depending on the number of items found (it contains directory listings for specified file names). That routine resizes/creates the fill list range name each time it runs.
When I create an ActiveX Combo linked to a cell on the same sheet and using a range for the "Fill List" that is on the same sheet, it works fine. Sliders appear on the drop down list no problem.
However, when I "save>close>open" the workbook (an .xlsm file, and macros are enabled), the sliders aren't there, even if the range contains more items than can fit on the size of the drop down list. (I'm not sure it is the close/open process that causes the problem - haven't uniquely identified the exact action that causes the slider to disappear.)
If I re-create the dropdown, it works fine, again, but then loses the slider again at some point I can't clearly identify, yet.
I've Googled "Excel Combo missing slider" and all sorts of related key words, but no joy on finding anyone reporting the same problem.
Anyone have similar experience, or can you offer a possible suggestion? I've experimented with most of the remotely connected properties of the Combo object, but can't find a solution.
Thanks.