Loads of FREE content on Microsoft Office Training

Category Archives

Archive of posts published in the category: VBA
Dec
29

Hiding Excel Worksheets with VBA

Got another great question from a student in my Excel VBA UserForms course on Udemy. QUESTION: I have built and Excel UserForm that allows users to interact with worksheets within a workbook. I don’t want the users to interact with the worksheets directly.…

Nov
11

Passing Values to an Excel VBA Procedure

I recently got a question from a student in my Excel VBA UserForms course on Udemy.  I love it when someone is able to take the material that I’ve created, in one of my courses, and look for ways to applied the concepts…

Nov
10

Automate Monthly Excel PivotTables with VBA

Another great question from a student of mine on one of my favorite Microsoft Excel features, PivotTables. QUESTION: “I were to receive a huge volume of data in Excel on a monthly basis and every time I have to do a pivot table on a…

Nov
7

SPEED UP EXCEL VBA PROCEDURE RUNTIME

I recently helped a student of mine with automating a series of tasks within Microsoft Excel with VBA. The tasks included; Identifying from 20,000+ line items which items where still in stock. (Used a VLOOKUP to compare current list with INSTOCK items) Removing…

Nov
4

Create a Folder with Excel VBA

A few posts back I wrote about managing files within a local directory from within Excel using VBA. Today I came across a great question, related question, in one of the Excel LinkedIn groups I participate in. This Excel user was looking for a…

Oct
31

Filter Columns in a Microsoft Excel List

Another AWESOME question from a student in one of my courses on Udemy. QUESTION: How can you create VBA code that will hide columns in an Excel list, based on cell values? Imagine you have a list within Excel that contains monthly data.…

Sep
12

Copy… Paste… with VBA

Another excellent question from a student in one of my courses on Udemy. QUESTION: … looking for VBA code to transfer data from a master list to individual files? Say a site list by manager? How would I loop thru each row of the…

Aug
24

Automate the IFERROR() Function with VBA

Another great question from a student in one of my courses on Udemy. QUESTION:  How can Excel automate the process of including the IFERROR() function into a column that contains formulas? Imagine you have an Excel list… In this list, you have a…

Aug
14

Comparing Excel Lists with VBA

Another great question from a student in my Master Excel VBA course on Udemy. QUESTION: Using VBA, how can you compare two Excel lists line by line? For example, you may have two lists of membership records from two different years. One for…

Aug
3

Using Excel as a Document Archiving Management Tool

I have been getting so many great questions from the students of my various courses on Udemy. The most recent question that I would like to share with you asks… How can I automate managing a large list of documents, stored in a folder…

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.