Beginners Excel VBA and Excel Macros

Explore Excel VBA topics with message boxes, from simple to advanced dialogs, and learn to prompt for input and perform actions such as emptying a sheet.

Learn to create a button in Excel, assign a VBA macro, and display a message box dialog that shows a welcome message when clicked.

Learn to display a cell’s contents via a button-triggered macro in Excel, and build an advanced message box with concatenation and line breaks.

Learn to use the message box function in Excel VBA to clear a sheet by attaching a macro to a button, prompting yes or no, and clearing the contents.

Learn to use the input box in Excel VBA, create a macro triggered by a button, and write user input to cell A1, with optional title and default value.

Explore the object hierarchy in Visual Basic and manage workbook and worksheet objects. Open and close workbooks by path, loop through worksheets, and build a sales calculator with chart types.

Demonstrate the Excel VBA object hierarchy from application to workbook to worksheet to cells, showing how a button triggers a macro and sets cell values.

Explore working with workbook and worksheet collections in excel vba, reference other sheets by name, index, or code name, and change cells across worksheets with a button macro.

Develop VBA skills to add and count worksheets in a workbook using the add method and worksheets.count, activated by a button and displayed in a message box.

Learn to get a workbook path with VBA by referencing a workbook by name or using the active workbook, and display results with message boxes.

Open and close Excel workbooks with VBA using direct open and get open file name methods, then close by name or by the active workbook.

Learn to loop through all open workbooks and their worksheets using a for each loop in VBA, displaying workbook and sheet names via a macro button.

Build a sales calculator in Excel using Visual Basic. The code loops across week one and week two sheets, prompts for a game name, and displays the total sales.

Learn to convert and customize Excel charts with Visual Basic, using macros to change chart types, titles, legends, and properties for dynamic chart manipulation.

Master the range object in Excel VBA by programming and selecting ranges, using the cells object, storing data in range variables, and performing copy-paste operations across worksheets.

Learn to use the range object in Excel VBA to programmatically populate single or multiple cells, set values, and work with named ranges via a button-driven macro.

Create a worksheet button to run a macro that uses the cells and range objects in Excel VBA, using row-first, column-second indices and dot value to set cells and ranges.

Learn to use the cells and range objects in Excel VBA, assign macros to a button, and modify values with the dot value property in the Visual Basic Editor.

Learn to use the range object's select method in Excel VBA, automating range selection with a macro and a button across worksheets.

Use a range object's rows property to select a row within a range, assign a macro to a button, and test row and column access in VBA.

Learn two ways to copy and paste a range in excel: using the range object directly by assigning the value property, and using copy-paste methods via macros.

Learn how to clear a range in Excel with VBA by using the range object and the clear contents method, including practical examples from A1:B9 and D1:E9.

Learn to count cells, rows, and columns in a range using Excel VBA by creating a macro tied to a button that displays counts in message boxes.

Explore the range object in Visual Basic and its properties for current and dynamic ranges. Learn to resize ranges, select rows and columns programmatically, offset ranges, and retrieve last value.

Learn to find and select a cell's current region in Excel VBA by using macros and the range object, where a region is bounded by empty rows and columns.

Discover how to create a dynamic range in Excel using VBA, add numbers, and automatically highlight the maximum value in the current region.

Learn to resize a range in Excel VBA using the range object and its resize property, with a button-triggered macro that reduces B2:E7 to the first column.

Learn to select entire rows and columns in Excel using VBA, by using the rows and columns properties and the select method, and to activate worksheets as needed.

learn to use the excel vba offset property to shift a range by rows and columns, and see a macro test highlighting the new offset range.

Learn to use the end property of the range object in VBA to always get the last entry, including ranges from an active cell and ending with the last value.

Explore Excel VBA range properties, union and intersection of ranges, and detecting content in ranges or cells; apply styling such as color, bold, and italic, and use the Areas object.

Learn to find the union and intersection of two Excel ranges using VBA, with ranges A1 to B4 and B2 to C4.

Learn how to detect cell content using a range object in Excel VBA, building a detect macro that identifies numbers and shows results in a message box.

Build a range-based VBA program that creates random game titles by combining two words from a data range, via a macro assigned to a button and nested loops.

Learn to change font color in Excel using VBA by creating a color macro, assigning it to a button, and setting a range font color with vbBlue or RGB values.

Learn to format Excel ranges with VBA by setting range font bold to true, record macros to automate actions, and assign them to a button for quick bolding and italicizing.

Learn to change a cell color using Excel VBA by creating macros that modify the interior color index, and explore clearing colors, getting color indices, and RGB options.

Learn to work with areas in Excel VBA by building a macro attached to a button, counting areas, and looping to show cells in each area.

Learn to compare two ranges in Excel using VBA by creating a macro that highlights unique values and outlines them with borders, teaching range selection, looping, and color highlighting.

Explore data types in excel vba, including integer, string, double, and boolean, learn variable creation, and review procedure, module, and public visibility levels and retain a variable's value over time.

Explore the integer data type in Excel VBA by declaring integer variables, storing whole numbers, and using a button-driven macro to insert a random integer into the sheet.

Learn to use string data type in Excel VBA by declaring a string variable, initializing it with quoted text, and placing the value into a cell via the value property.

Explains how the double data type in Excel VBA preserves decimal places, contrasts with integers, and shows how to declare and initialize a double variable to avoid rounding errors.

Learn how the boolean data type in Visual Basic uses true or false with conditionals and if statements, and drive a message box when a hungry boolean is true.

Learn how to retain a variable value in Excel VBA by declaring it as static, so its value persists across button clicks and displays the updated total by two.

Explore conditionals in Excel VBA, building if-then and else statements to control code flow based on conditions such as a number being less than a million.

Learn how to use the if then statement in Excel VBA, declare integer variables, test A1 against 100, and update B1 with a valid number when the condition holds.

Master how to use the else statement to chain onto an if, handling inputs from A1 to produce hi there or goodbye in Excel VBA, and test results in B1.

Overview of the three key logical operators (and, or, not) and how they combine conditionals to create more nuanced Visual Basic programs for Excel, enabling more complex data-driven decisions.

Explore how the logical and operator combines conditions to run code only when multiple checks pass, shown by a time-based greeting that outputs good morning or hello there.

Learn how to use the logical or operator in Excel VBA to create a macro that tests two scores for a pass, using conditional statements and an if else structure.

Master the not operator in Excel VBA to test conditions like not zero using a button-triggered macro that updates B1 based on a score in A1.

Learn select case for conditionals, apply the mod operator, and build VBA projects that calculate commissions, check numbers, sort by color, and clean up spreadsheets.

Use the select case statement in Excel vba to map a 1–5 review input to text like negative, neutral, good, or excellent and display the result in a cell.

Build a sales commission calculator in Excel VBA by coding a button-click macro, using total sales and a select case to calculate commission, with a zero default.

Learn to use the mod operator in Excel VBA to get the remainder of division, tested with a button and message box, with examples like 10 mod 2 = 0.

Build a prime checker in Excel VBA by attaching a macro to a button, looping from 1 to the input number, counting divisors via modulo, then showing the result.

Learn to build an Excel VBA macro that finds the smallest and second smallest values in a selected range, handles decimals, and displays the result in a message box.

Group cells by font style in Excel using VBA, collecting green words from column a and displaying them in a message box.

This lecture shows how to remove empty cells in Excel via a VBA macro and a button, moving nonempty cells from column a to column b and back.