Hi,
Is there any way a user can select a spot on the scrollbar and the bar moves there instantly?
I have my scrollbar in place so that the user can answer a question to choose between a digit 0 and 21 (the value goes to cell A1). However you have to click multiple times to get the scrollbar to the desired position. You cannot even use the mouse to move the scrollbar.
Any clues would be appreciated!
(using VBA 14.2.5 on MS Excel for Mac 2011)
Is there any way a user can select a spot on the scrollbar and the bar moves there instantly?
I have my scrollbar in place so that the user can answer a question to choose between a digit 0 and 21 (the value goes to cell A1). However you have to click multiple times to get the scrollbar to the desired position. You cannot even use the mouse to move the scrollbar.
Any clues would be appreciated!
(using VBA 14.2.5 on MS Excel for Mac 2011)
Code:
Private Sub ScrollBar1_Change()
Range("A1") = ScrollBar1
End Sub