how to use a scrollbar to select values instantly

[Chicken6]

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)

Private Sub ScrollBar1_Change()
Range("A1") = ScrollBar1
End Sub

 

[Chicken6]

Ahhh, figured it out. Go to the properties windows for the scroll bar, and set the delay to 1. The scroll bar goes straight there.

Now for the next problem, and that is that the scroll bar ends up to the right (it's a horizontal scroll bar) of where you click on the scrollbar continuum. The more to the right, the greater the difference between where you click and where the scroll bar ends up.

hmmm... Maybe another thread.