ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ActiveX Control Item Numbers (https://www.excelbanter.com/excel-programming/369068-activex-control-item-numbers.html)

Mark

ActiveX Control Item Numbers
 
Hi,

I have a spreadsheet with about 60 slider bars all of which I get to change
colour using VBA when the values are not equal to targets held in adjacent
cells. I have hit the snag that the index number for the sliders does not
necessarily equal the Scrollbar"xx" number. How do I match/change or even
reference the Scrollbar Item number so that I can refer to them individually.

Thanks in advance.


All times are GMT +1. The time now is 09:33 AM.

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