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.
Description
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.
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.
English
language
Content
Introduction
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