Hi all,

I'm using a scrollbar as a "slider" of sorts in a survey. A cell link allows me to convert this into a numerical input. See example.

Screen Shot 2018-08-23 at 8.53.10 PM.png

My goal is for the user to be able to click anywhere on the bar and it instantly jump to the place clicked. The default implementation is that the scroll bar moves in the direction clicked by the "incremental change" value set in properties. I want to change it so that if the user clicks in the middle of the bar, it immediately jumps to 50.

Any tips on how to approach this? Can VBA help me?

Thanks very much for your thoughts.

pdb