Want to learn Excel Macros & VBA in depth? ✅ Check out my course: go.launchexcel.com/macros-vba-school-youtube *Download the FREE Excel Workbook* Step 1: Sign up for free: go.launchexcel.com/email-signup-youtube Step 2: Log in here: courses.launchexcel.com/dashboard/en/login Step 3: Download: courses.launchexcel.com/school/course/workbook-downloads/lecture/5612592#headline-9a3b3ace TIP: Stay logged in for quick access to ALL workbook downloads *Click here for the article with full VBA code:* www.launchexcel.com/excel-macros-and-vba-tutorial-victor-consulting-company *Chapters:* 00:00 Are you driving Excel in first gear? 00:29 WHAT IS A MACRO? 01:14 Record your first macros ↳ 02:45 View Tab & list of macros ↳ 04:23 Customize Ribbon ↳ 05:00 Relative vs Absolute References ↳ 05:51 Record macro 1 (Highlight) ↳ 07:45 Test macro 1 ↳ 08:28 Record macro 2 (Un-highlight) ↳ 09:31 Test macro 2 10:08 Mission: Use VBA to upgrade our macros ↳ 10:41 How will we fix our macros? ↳ 12:00 Access the Visual Basic Editor ↳ 13:50 Switch back to Excel (ALT + F11) ↳ 14:21 Combine VBA code ↳ 18:02 Assign keyboard shortcut (CTRL + SHIFT + K) ↳ 18:46 Assign to button 20:57 Use macros to filter data ↳ 21:22 Turn data into a Table (CTRL + T) ↳ 22:07 Reveal the Developer Tab ↳ 22:49 Record new macros ↳ 25:13 Add shapes to run macros 27:45 Use macros to sort data ↳ 27:59 Turn off relative references to record ↳ 28:45 Add macros to shapes ↳ 31:47 There is no undo! ↳ 32:01 Sort by original row order ↳ 33:10 Custom sort on several columns 36:21 The Time I Almost Got Fired... 38:36 A Chance Encounter Leads to... 40:29 Will You Take This Opportunity? *Learn Macros and VBA with me* STOP Wasting Time on Repetitive Tasks with Excel VBA go.launchexcel.com/macros-vba-school-vsl-youtube
Around 20:20 the toggle doesn't work properly. Rows 14 and 16 are not bold but after the macro was run they still were not bold. They should be highlighted.
Yes, thanks for pointing it out. Simple answer is that I decided to keep things easy for this beginner's video. Longer answer is that I chose a very easy change to the VBA code so it only looks at the one active cell, and checks if that active cell is bold. To truly toggle every row between 0 (not highlighted) and 1 (highlighted) we need to use a "For Each" to check if the first cell in each row in the selection is bold or not. For this introduction video I decided to keep things simple. My course goes into "For Each" and much more. Hope that helps.
It is good to know the basics of Excel macros, but it is worth using an artificial intelligence program to write the code itself. I have, for example, made a very extensive stock market investment program using Excel macros to automate it. I am an application developer myself and the artificial intelligence program is a coder. This of course requires that every time I have made the code, I test it in use.
Thanks for your comment. Yes I agree, using AI to write code is becoming more viable for complex code every month that passes. It seems that the past year has seen a remarkable rise in the ability of AI to generate working code. Using AI for VBA works too. What AI tools do you like the most?
Want to learn Excel Macros & VBA in depth?
✅ Check out my course: go.launchexcel.com/macros-vba-school-youtube
*Download the FREE Excel Workbook*
Step 1: Sign up for free: go.launchexcel.com/email-signup-youtube
Step 2: Log in here: courses.launchexcel.com/dashboard/en/login
Step 3: Download: courses.launchexcel.com/school/course/workbook-downloads/lecture/5612592#headline-9a3b3ace
TIP: Stay logged in for quick access to ALL workbook downloads
*Click here for the article with full VBA code:*
www.launchexcel.com/excel-macros-and-vba-tutorial-victor-consulting-company
*Chapters:*
00:00 Are you driving Excel in first gear?
00:29 WHAT IS A MACRO?
01:14 Record your first macros
↳ 02:45 View Tab & list of macros
↳ 04:23 Customize Ribbon
↳ 05:00 Relative vs Absolute References
↳ 05:51 Record macro 1 (Highlight)
↳ 07:45 Test macro 1
↳ 08:28 Record macro 2 (Un-highlight)
↳ 09:31 Test macro 2
10:08 Mission: Use VBA to upgrade our macros
↳ 10:41 How will we fix our macros?
↳ 12:00 Access the Visual Basic Editor
↳ 13:50 Switch back to Excel (ALT + F11)
↳ 14:21 Combine VBA code
↳ 18:02 Assign keyboard shortcut (CTRL + SHIFT + K)
↳ 18:46 Assign to button
20:57 Use macros to filter data
↳ 21:22 Turn data into a Table (CTRL + T)
↳ 22:07 Reveal the Developer Tab
↳ 22:49 Record new macros
↳ 25:13 Add shapes to run macros
27:45 Use macros to sort data
↳ 27:59 Turn off relative references to record
↳ 28:45 Add macros to shapes
↳ 31:47 There is no undo!
↳ 32:01 Sort by original row order
↳ 33:10 Custom sort on several columns
36:21 The Time I Almost Got Fired...
38:36 A Chance Encounter Leads to...
40:29 Will You Take This Opportunity?
*Learn Macros and VBA with me*
STOP Wasting Time on Repetitive Tasks with Excel VBA
go.launchexcel.com/macros-vba-school-vsl-youtube
Around 20:20 the toggle doesn't work properly. Rows 14 and 16 are not bold but after the macro was run they still were not bold. They should be highlighted.
Yes, thanks for pointing it out. Simple answer is that I decided to keep things easy for this beginner's video.
Longer answer is that I chose a very easy change to the VBA code so it only looks at the one active cell, and checks if that active cell is bold.
To truly toggle every row between 0 (not highlighted) and 1 (highlighted) we need to use a "For Each" to check if the first cell in each row in the selection is bold or not.
For this introduction video I decided to keep things simple. My course goes into "For Each" and much more.
Hope that helps.
It is good to know the basics of Excel macros, but it is worth using an artificial intelligence program to write the code itself. I have, for example, made a very extensive stock market investment program using Excel macros to automate it. I am an application developer myself and the artificial intelligence program is a coder. This of course requires that every time I have made the code, I test it in use.
Thanks for your comment. Yes I agree, using AI to write code is becoming more viable for complex code every month that passes. It seems that the past year has seen a remarkable rise in the ability of AI to generate working code. Using AI for VBA works too. What AI tools do you like the most?