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: https://excelvbaisfun.com/mdocs-posts/excel-vba-userform-scrollbar-change-by-10-even-when-dragging/

 

Thanks

Dan Strong, excelvbaisfun

You Might Also Like

Create Sheets For Each User From Column A

Create Sheets For Each User From Column A

Sometimes in Excel, we need to automate simple tasks, like to create sheets automatically for each item in a range. If you just had a few worksheet tabs that needed to be created, it wouldn't be a big deal, but what if you had to create 100 different worksheet tabs?!...

How To Add A Date Picker Calendar in Excel VBA

How To Add A Date Picker Calendar in Excel VBA

Date Picker Calendar in Excel VBA Oftentimes, users want to click a button and select a date. This is no different for Excel developers. Check out this ActiveX control by Microsoft that allows users to do just that. It's a little old school looking, but actually has...

X

Forgot Password?

Join Us