excelvbaisfun Blog

Latest News


Check out the latest articles on making your life more fun with Excel VBA!

6 Oclock and 12 Pm Don’t Appear Correctly on Userform

Sometimes using a text box on a user form or on a worksheet doesn't work exactly the way we think it should. This is especially true when were working with dates and times straight from a worksheet. The problem we faced when helping Emil was that the format function...

Excel VBA Userform Scrollbar Change By 10 Even When Dragging!

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...



FREE eBook for Subscribers

As an additional “Thank you”, you’ll receive my eBook “Essential Excel VBA Snippets”.

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

Pin It on Pinterest

Share This