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