Excel VBA Scrollbars are awesome for visually and easily changing a value, but there is one limitation – when you click the square in the middle and drag it, you can’t automatically make it snap to the neares NN value! Until now!

Check out how we resolve this with a quick and painless hack:


FREE Workbook download here: http://excelvbaisfun.com/mdocs-posts/excel-vba-userform-scrollbar-change-by-10-even-when-dragging/



Dan Strong, excelvbaisfun

You Might Also Like

Excel VBA UserForms #2

Excel VBA UserForms #2 Create a UserForm with 2 option buttons:  1 Sort by Employee ID or 2 Sort by Name. Part one, create the UserForm and give it buttons. First, bring up the VBA UserForm editor (F11), and add a new UserForm  using the...

Excel VBA Userform Basics #1

UserForm Basics #1 Here, you'll learn to make a UserForm, add a button, and make clicking on that button hide the UserForm! Make a UserForm: Press Alt-F11 to bring up Visual Basics menu Click the drop down menu in the upper left hand and select...

Password Reset
Please enter your e-mail address. You will receive a new password via e-mail.

Pin It on Pinterest

Share This

Share This

Share this post with your friends!