Download Udemy – The Ultimate Excel Programmer Course 2021-11

Automate and customize data entry forms

Choose the right ring for every task

Master CELLS and RANGE objects in multiple scenarios

Create multiple variable styles to match your needs

Customize your VBA editor and understand all the toolbars and options

Debug and troubleshoot code like a boss!

Record, modify or write macros from scratch

Build custom formulas/functions on the fly

Review IF THEN statements and conquer all logical operators

Collect interactive message boxes, inboxes and give users options!

Create basic printable reports

Add filters to report menus to limit records

Take control of forms, buttons, drop-down menus, checkboxes and radio buttons and much more. . .

Trigger code in a number of different ways – from clicking a cell – to deselecting a worksheet.

Set special commands when a workbook: is opened or closed, selected, any specific cell or cells are selected, just before printing, etc. .

Manipulate Userforms to enter data, generate reports, edit tables/databases – all under your control. Limit the flow of data or make the user form(s) responsive, computational, and intuitive.

Simplify your work and others.

Put Excel on autopilot. . .

Running macros using worksheets and UserForm controls (buttons, shapes, popups, list boxes, click actions, lots of fun controls)

Change cell properties using code – cell color, font properties (bold, italic, underline, etc.), borders, and more!

Begin advanced math with variables and learn proper usage, declaration, and scope

Learn string functions, concatenation and how to control case sensitivity with VBA functions

Create your own functions for use in VBA or cells!

Advanced search functions are only available in VBA

Fun with date and time math to calculate duration, length and distances

Projects: Build complete games, learn from coding exercises, and enjoy mid-lecture challenges!

Discover and master VBE (Visual Basic Editor) and all its mysterious buttons and features!

Cope with mistakes and learn how to avoid them

Feed data from one macro to another using the ByRef and ByVal methods

Use all types of variables: constant, static, module level, public, private, “module private option” etc.

Bonus #1: Free eBook “Excel VBA Master Keyboard Shortcuts” – now with more shortcuts (for PC and Mac) than anywhere else

Bonus #2: Free image tools for better form buttons, images, and backgrounds

Bonus #3: Free mouse icon packs to customize the MouseOver effect on many controls including the UserForm background!

Three ways to access the worksheet using code

Get the borders of a range of cells the way the pros do (better LastRow and LastCol techniques)

Dynamic sorting or data filtering You can have multiple sorting options, each assigned to a different button!

Using user input (message boxes, input boxes, user forms) and using conditional logic (IF THEN, CASE STATEMENTS, AND, OR, NOT) to control direction

Enter worksheet functions programmatically using regular notation or R1C1 in cells

Practice code leanness and efficiency techniques, such as WITH/END WITH statements.

Supercharge your code with Don’s VBA speed hacks

Get random numbers to generate passwords, generate filenames, generate random actions in games/projects, speed tests

Search cells and strings with advanced pattern matching and comparison, such as the InStr operator and functions

Advanced message box features (including special icons, directions, buttons: yes/no, yes/no/cancel, cancel/retry and many more…)

Create optional UDF parameters and select volatile or non-volatile functionality