Excel Scroll Bar ActiveX Control Query

[AndyJohnD]

hello,
I am trying to set the ScrollBar1.Value within ScrollBar1_Change().
When I set it to a constant, 2,3..... etc or a temp variable set to 2,3...etc
the Scroll Bar works as expected. However, I am trying to set it to a variable, and when I try this I get an error.

Here is the first subroutine that works

Private Sub ScrollBar1_Change()

SB_1 = ScrollBar1.Value
​

If Range("H5") > 10 Then

Temp = 4
ScrollBar1.Value = Temp
​

End If
Range("B5").Value = SB_1
​

End Sub

This subroutine produces an error at the highlighted line

Private Sub ScrollBar2_Change()

SB_2 = ScrollBar2.Value
​

If Range("H5") > 10 Then
​

SB_2 = SB_2 - 1
​

ScrollBar2.Value = SB_2
​

End If
​

Range("E5").Value = SB_2
​

End Sub

I am probably doing something daft
thanks very much for any help