• Post category:StudyBullet-16
  • Reading time:13 mins read

Elevate Your VBA Skills with Practical Functions for Business Applications

What you will learn

Master 105 Excel VBA functions through real-life business scenarios.

Adopt advanced VBA programming techniques for robust application development.

Establish a solid foundation for creating efficient, professional-grade Excel VBA applications.

Implement user interaction dialogues for enhanced application usability.


Dive into “Excel VBA Functions Masterclass: 105 Real-World Examples“, where practical learning meets real-world application, elevating your Excel VBA skills beyond conventional boundaries. This course stands out by offering you a hands-on, learn-by-example journey through 105 Excel VBA functions, each selected for its proven impact in business environments.

Marcel Eggen from The Netherlands says, “Since I have started your 105 Excel VBA Functions course on Udemy, I have become a big fan of your approach. This course is not just a basic VBA course but it actually generates useful tips for real-life problems.” Like Marcel, you’ll discover the unique value of applying these functions directly to your projects.

Why This Course Is Unique:

You’re not just learning VBA; you’re gaining access to a library of functions that address real-life business challenges. Each function is accompanied by a detailed video explanation, where I break down the code, sharing insights on programming best practices and VBA master secrets.

Get Instant Notification of New Courses on our Telegram channel.

Enhance Your Applications:

  • Real-World Functions: Directly apply each of the 105 functions to your daily tasks and projects, solving complex business problems efficiently.
  • Professional User Interaction: Learn to create user interaction dialog boxes for a more polished, professional look, improving the end-user experience.

Course Highlights:

  • Actionable Insights: Understand the thought process behind each function’s design, enhancing your ability to develop your own VBA solutions.
  • Downloadable Function Library: Access the 105 Excel VBA Functions Pack* for a comprehensive toolkit that will become indispensable in your development work.

*Note: Your name and email are required to download the 105 Excel VBA Functions Pack from my website, providing you with additional valuable content on computer programming and business applications. You can always opt-out of this list.




Course structure and contents

Array Functions

Section Intro: what is an array?
Check if array is dimentioned
Match a value for its index along a 2-D array column or row
Match a value for its index along a 1-D array column or row
Transpose a 2-D array
Sum numeric values in a column of a 2-D array

Application Control Functions

Section Intro: controlling the application
Check if your program is in Production mode
Restore the State of the application to normal

Data Export/Import Functions

Section Intro: text files
Export an Excel Table as a csv file
Export a Worksheet as a csv file
Export an array as a csv file
Import a csv file into an Excel Table
Import a csv file into a Worksheet

System Input/Output Functions

Section intro: Input/Output
Delete a file
Extract the file name out of a full path
Convert a file name to a Windows legal file name
Delete old files in a folder
Get the storage drives list from Windows
Move a file
Copy a file
Check if a file exists

Notification Functions

Section Intro: notification
Present a message to the user in the application Status Bar
Clear the application Status Bar

Printing Functions

Section Intro: printing
Check if the printer is turned on and ready
Print out a Worksheet
Sets rows as repeating rows in PageSetup for printing

Protection Functions

Section Intro: protection
Protect a Workbook
Unprotect the Workbook
Protect a single Worksheet
Unprotect a single Worksheet
Protect all Worksheets in a Workbook
Unprotect all Worksheets in a Workbook

Reports Functions

Section Intro: reports
Formats a column of cells
Formats a column of cells in an Excel Table
Apply (or remove) WrapText to a range of cells
Draw borders around a range: sides, color, weight
Apply formatting to a row of a report
Appliy fill and/or font color to a column(s) of cells
Apply fill and/or font color to a column(s) of cells as a conditional formatting
Clears content and formatting from all cells of a report

Search & Navigation Functions

Section Intro: search & navigation
Find a text string in a Worksheet
Get the column letter by its index
Activate the startup Worksheet specified by the user

Worksheets & Workbooks Functions

Section Intro: Worksheets & Workbooks
Check if a Worksheet-scope range name is defined
Hide all Worksheets flagged with a Worksheet-scope range name
Hide a single Worksheet
Unhide a single Worksheet
Check if a Worksheet is currently hidden
Check if a Worksheet exists and visible
Copy a Worksheet to a newly created Workbook
Open an Excel file if not already open
Check if a Workbook is currently open
Create a new Worksheet
Close a Workbook

Windows System Functions

Section Intro: Windows system
Get the logged-in Windows user name
Get the computer name running Excel
Get the local PC country code
Get the full path to the Windows temporary folder
Pause execution of the program

Excel Tables Functions

Section Intro: Excel Tables
Add a new row to a table
Delete row of current cell within a table
Add a new row at the end of the table with values
Fills a row of Fields in a Worksheet with values
Delete a complete Worksheet row by its index
Delete a row from a Worksheet matched to a Value in a Column
Remove last row of a table
Update column value of rows matching a column value
Resize a table
Get the number of data rows in a table
Get the number of columns in a table
Get the Worksheet row of record matched to a key
Get the Worksheet row of a newly added row
Get the Worksheet row of table record matched to a key
Get the Worksheet column in which a column header is found in a table
Sort a table
Delete table rows except first rows
Clear a table’s non-formulas cells and delete rows
Get a table cell value matched by row index and column name
Vlookup implementation on a table
Vlookup with cell update on a table
Load all rows of a table column into an array
Find & Replace in cells of a table column
Apply an array to a table
Get the table index row of the active Worksheet cell
Reset all filters of a table

User Interaction Functions

Section Intro: user interaction
Pop up a login dialog box to the user
Pop up a message box with a single “Close” button and a warning icon
Pop up a dialog requesting some input from the user
Pop up a message box with a “Yes” and “No” buttons
Pop up a message box with a single “Close” button and a confirmation icon
Control user input length in a text control on a user form
Get Worksheet name of active cell
Get value of active cell
Get Worksheet row of active cell
Worksheet column index of active cell
Get the value of intersection of current active cell row and a Worksheet column
Get the value of intersection of current active cell column and a Worksheet row
Expand Excel data area to full screen
Restore Excel data area to regular size
Show or hide Worksheet rows and columns headings
Close the Excel application or just the active Workbook