Free Excel VBA Course #23 - Event Procedures in VBA

Рет қаралды 19,435

4 жыл бұрын

In this video, I will show you what event procedures are and how to use these in Excel VBA.
An event is an action that can trigger the execution of the specified macro.
For example, when you open a new workbook, it’s an event. When you insert a new worksheet, it’s an event. When you double-click on a cell, it’s an event.
There are many such events in VBA, and you can create codes for these events. This means that as soon as an event occurs, and if you have specified code for that event, that code would instantly be executed.
Some of the events include:
-- Worksheet Level Events
-- Workbook Level Events
-- Application Level Events
-- UserForm Level Events
-- Chart Events
✅ Download file: bit.ly/vbacourse-23
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzfaq.info...
#Excel #ExcelTips #ExcelTutorial

Пікірлер: 14

@redhaakhund1271 2 жыл бұрын

Great! thank you so much for the video

@kebincui Жыл бұрын

great tutorial, thanks

@margad-erdeneboldbaatar4704 2 жыл бұрын

Thanks so much.

@JATINKUMAR-qu4vi 2 жыл бұрын

Great video

@dianat.sandoval2561 3 жыл бұрын

thanks!

@bluex5115 3 жыл бұрын

easiest way to use NOT > Target.Font.Strikethrough = Not (Target.Font.Strikethrough) .. and for all type of activate/deactivate same :)

@kcs-dj3ec 2 жыл бұрын

Sir, I have one complaint. The font of the code you write is too small to read. Pl increase/magnify the editor window.

@pravinvasudevan 4 жыл бұрын

Hello Mr.Sumit, the way u teach VBA is awesome. thank you for your efforts and hardwork. cud u pls share macro of hw to freeze top row in excel where I have my first header, until I scroll down and reach a particular row where I hve another header and when this second row scroll up to reach the first row, then the second row will get freeze and the first row will get unfreeze. and again if I scroll up then the second row will get unfreeze and first row will get freeze. it should work with mouse scroll, down arrow scroll or side scroll bar. thank u so much

@vaibhavjain6619 5 ай бұрын

I think you will use freeze pannes from view tab just normally put ur cursor below the data which you want to be freezed then go with it ,if don't want that just unfreeze the panes by again clicking on freeze pannes

@umamaheshk6151 3 жыл бұрын

i am using MS Office2007 version. I couldn't find the dropdown list which u have shown @2:06 (I found a few). What I have to do?

@alteavanloggerenberg2464 9 ай бұрын

Hi, I hope you can assist. I have a workbook with 11 sheets. How would I go about triggering a macro event that is only applicable to 7 of the worksheets. Any change in the specific 7 sheets, would then trigger the macro to run. Any assistance would be greatly appreciated.