Each VBA Tutorial contains macro examples to help you learn VBA code quickly. Follow these VBA tutorials to learn basic and advanced Excel macro programming.
Prevent your screen from updating until your Excel macro is finished with Application.ScreenUpdating=False. The Application.ScreenUpdating property is useful when running macros that jump from cell to cell, sheet to sheet, and workbook to workbook.
Outlook search not working? Use this VBA code example to search through your email inbox. This tutorial shows you how to regain search functionality if you are one of the thousands of people whose Outlook instant search function has stopped working.
We've combined each of our comprehensive wellsrPRO VBA training reference guides into a single bundle with over 200 tips and macros covering the 125 most important topics in VBA.
Change your coworker’s cursor to the Peanut Butter Jelly Time dancing banana with this MS Word VBA tutorial. The VBA code example stores byte strings in your Custom Document Properties so every time your colleagues open your Word document, the banana animated cursor will be restored and activated on their computers.
Find differences between two excel columns with this VBA tutorial. The VBA module loops through columns of unknown length and unknown order. It compares the longer list to the shorter list, highlights differences and outputs a “key” that points to the matching cells.
The VBA snippet End(xlup).Row will find the last used row in an Excel range. Knowing the last row in Excel is useful for looping through columns of data.
We just added a 6th cheat sheet to our training bundle. With our new guide on VBA UserForms, our bundle now has over 200 tips like how to automate data extraction from text files, how to remove duplicates from an array, and how to dynamically populate a listbox.
Use this Trapezoidal Rule Excel Function to approximate the definite integral of paired data sets. A VBA Excel function to find the area under a curve is useful in engineering, business, finance and many scientific fields.
This VBScript example creates a desktop exercise reminder that sleeps in the background and reminds you to take a break every 45 minutes. If you’re an office worker, this example is sure to help you battle the sedentary lifestyle.