Hi, I need a little help if anyone knows how to do this. I have a worksheet that has 51 scrollbars on it that are used like a slider to weight different metrics based on a particular users perspective. I wanted to know if there is a For each .. next or something I can use to change the properties for all of them as a group instead the tedious manual way. It's 5 properties I need to change:
For Each of the 51 Scrollbars
ScrollBar1.BackColor = RGB(2, 20, 56)
ScrollBar1.ForeColor = RGB(255, 255, 255)
ScrollBar1.Orientation = Vertical
ScrollBar1.Height = 88
ScrollBar1.Width = 12.4
Thank you in advance if anyone knows how to do this.
Rayburn
Bookmarks