I have an ActiveX ScrollBar and want to set the Max value to the contents of an Excel Cell so that it becomes variable. What is the VB coding? So far I have:
Private Sub ScrollBar1_Change()
Dim cell As Integer
cell = 200
ScrollBar1.Max = cell
End Sub
Which works. I now want to change the '200'...