Thanks for watching this video about using the Excel Macro Recorder to learn simple VBA. You can get your free e-book and email course at the following link: DOWNLOAD EBOOK → launchexcel.lpages.co/first-macro-ebook Please do leave comments below with any questions you have about learning Macros and VBA for Excel. And click on the LIKE button if you found this video helpful. Thanks for supporting my channel!
Hello victor one question has been in my mind for several years that Macros are a sort of one step ahead of Conditional formatting. Thanks for all the videos
Awesome video. i love your channel.It would be awesome if you upload videos about entrepreneurship using excel. Just because its a hot topic and i think you get a lot of growth on this channel. Maybe by starter how to create a good to do list about project or how to analyze market.
Yeah. Excel is vital in every business. You have a great voice, calming and the worksheets are clean and perfect. Look for good keyword search and mix things up with it. I'm sure you can get into 100k soon. And teach udemy course too. You have natural calming voice which works like magic on people.
Hello Victor! Ive watched all your videos so far and you're really good at teaching this stuff. For work though I have to graph and I did some work on my own and figured out that I can make a graphing macro but it does not change the range based on how many numbers I have to graph. Is there anyway to make it so that the range is flexible and graphs all the cells that have numbers instead of basing the graphing on the range originally set in the macro? I hope this makes sense, if not let me know and i can try to simplify it. Thank you again for the awesome videos!
Hi Fuzzysuperpi. Thanks for your feedback on my videos! I recommend you check out the .CurrentRegion property, which generally selects a rectangular block surrounded by one or more blank rows or columns. Here's one reference: www.informit.com/articles/article.aspx?p=2021718&seqNum=14
Sure... let me explain. From 12:58 onwards I talk about Excel worksheet change events. These are subroutines that run automatically when something happens on an Excel worksheet. For example, if you select a new cell then the subroutine "Worksheet_SelectionChange" is automatically run. And if you change the value of a cell then the subroutine "Worksheet_Change" is automatically run. There are two subroutines in Sheet3 - the one I explain in the video is Worksheet_SelectionChange. These subroutines don't go in normal VBA code modules - they must be stored with the worksheet (in this case Sheet3). Let's say we start on Sheet3 in cell A1. When we change the selection to B2, the subroutine "Worksheet_SelectionChange" is automatically fired up. All the code in that subroutine runs, and it changes the background color of the cell B2. And if we select another cell, say C1, the subroutine "Worksheet_SelectionChange" runs again. In this case it changes the background color of the cell C1. Hope that helps! - Victor
Thanks for watching this video about using the Excel Macro Recorder to learn simple VBA. You can get your free e-book and email course at the following link:
DOWNLOAD EBOOK → launchexcel.lpages.co/first-macro-ebook
Please do leave comments below with any questions you have about learning Macros and VBA for Excel. And click on the LIKE button if you found this video helpful. Thanks for supporting my channel!
Very nice series, thanks kindly bud
Hello victor one question has been in my mind for several years that Macros are a sort of one step ahead of Conditional formatting. Thanks for all the videos
Awesome video. i love your channel.It would be awesome if you upload videos about entrepreneurship using excel. Just because its a hot topic and i think you get a lot of growth on this channel. Maybe by starter how to create a good to do list about project or how to analyze market.
Thanks Alyx. That's a cool idea. Do you have an interest in entrepreneurship?
Yeah. Excel is vital in every business. You have a great voice, calming and the worksheets are clean and perfect. Look for good keyword search and mix things up with it. I'm sure you can get into 100k soon. And teach udemy course too. You have natural calming voice which works like magic on people.
Hello
I want to use VBA code to delete raw with the cell value multiple time and a different value in the cell please help to find the solution.
Hello Victor! Ive watched all your videos so far and you're really good at teaching this stuff. For work though I have to graph and I did some work on my own and figured out that I can make a graphing macro but it does not change the range based on how many numbers I have to graph. Is there anyway to make it so that the range is flexible and graphs all the cells that have numbers instead of basing the graphing on the range originally set in the macro? I hope this makes sense, if not let me know and i can try to simplify it. Thank you again for the awesome videos!
Hi Fuzzysuperpi. Thanks for your feedback on my videos! I recommend you check out the .CurrentRegion property, which generally selects a rectangular block surrounded by one or more blank rows or columns. Here's one reference: www.informit.com/articles/article.aspx?p=2021718&seqNum=14
Victor Chan thank you I will definitely check that out
Well , i didn't quite understand he event part.Could you help me rgarding that?
Sure... let me explain.
From 12:58 onwards I talk about Excel worksheet change events.
These are subroutines that run automatically when something happens on an Excel worksheet.
For example, if you select a new cell then the subroutine "Worksheet_SelectionChange" is automatically run.
And if you change the value of a cell then the subroutine "Worksheet_Change" is automatically run.
There are two subroutines in Sheet3 - the one I explain in the video is Worksheet_SelectionChange. These subroutines don't go in normal VBA code modules - they must be stored with the worksheet (in this case Sheet3).
Let's say we start on Sheet3 in cell A1. When we change the selection to B2, the subroutine "Worksheet_SelectionChange" is automatically fired up. All the code in that subroutine runs, and it changes the background color of the cell B2.
And if we select another cell, say C1, the subroutine "Worksheet_SelectionChange" runs again. In this case it changes the background color of the cell C1.
Hope that helps!
- Victor