excelvbaisfun Blog

Latest News


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

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

Getting the Last Row with Excel VBA

One of the most important things you'll learn in Excel VBA is grabbing the last row in your code. Here's how to do it. Let's say we need the bottom used cell in column A (column 1), we can copy/paste this code for the row number: [cc lang="vbscript" lines="-1"...



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