Excel Vba Amazing and Phenomenal Events - Series9
4.6 (3 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
22 students enrolled

Excel Vba Amazing and Phenomenal Events - Series9

You are going to learn amazing chapter here. Unleashing the power of VBA Events. Self trigger macros.
4.6 (3 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
22 students enrolled
Created by ajay parmar
Published 5/2018
English
English [Auto]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 7 hours on-demand video
  • 1 article
  • 4 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • You will be able to make the macros which run on conditions like if any change happens in a cell or before saving excel file or going from one sheet to another. These are all called events and they do not need any button to run macros . They are self triggered macros and they run whenever there is a condition match found.
Course content
Expand 10 lectures 06:48:13
+ Introduction to Excel VBA EVENTS
10 lectures 06:48:12

What are events.

What are different type of events. Their use and practical use.

We are discussing each and everything in this series about events and i have uploaded projects also for you so that you can not only understand the events but their use. One of the best feature or topic in VBA. So powerful and so stylish and so much capable of doing complex tasks in just seconds. Watch all lectures one by one.

Preview 02:14:11
Introduction to Events Part1
01:01:53
Introduction to Events Part2
01:12:58
Introduction to Events Part3
09:01

A quick demo to show you the power of Events . If you have not learnt this - you have not learn VBA. This is one of my Favorite topic guys. Come and learn the Events -self triggered macros .Also called conditional based macros which get run then condition provided by programmer meets.

Introduction to Events - Part4
19:03

another quick example to show you the power of events. This video is using send keys with events. Great video to see the power of Events. After this start your real learning

Introduction to Events Part5
08:42

See the power of CHANGE Event in this example. When you put the status of work done as "Done" in excel sheet -after 30 min from it an email will trigger automatically. If you need to understand the outlook connectivity with excel VBA please go and check my outlook series . You will learn everything from scratch.

Introduction to Events Part6
23:38

If you want to highlight row when you select a cell in excel how you can do it with the help of Events. This project is amazing because this not only talks about selection change event but how while writing the code you can expect some unimaginable errors and then how we can plan to sort out them . Its a 25 min great learning.

Student question- how to Select row on selection
29:48

this project shows us the use of selection and change event in single vba code.Here, we are using send keys to show drop down of data validation and this happens via vba. See the use of send keys and how excel functions are used to create this magic.

Preview 48:03
Requirements
  • Good knowledge of Public,local and module level variables . Good knowledge of Loops , IF Functions and Collection loops is needed.
Description
  • This course is meant for those students who know basics of vba very well like variables loops and arrays. We are taking a deep dive in Events and learning them from scratch.

  • Events can do wonder to you projects and if you do not know them you cannot call yourself a completer program. Putting conditions like if any change happen in a cell , run a macro or when sheet deactivates or activates - run a macro and do some job. These sort of macros you will be able to make after completing this program.

  • What is application.intersect term in events and how why where we use them.

  • If Events use in sheets or entire workbook - the difference .

  • How to use the Undo commands using vba -undo syntax. Generally, we use ctrl+z to undo in excel but Can it be done in VBA too? How Events can work with this undo command and what is the role of undo command in projects made on events.

  • How we can go ahead and Create log details using events in Excel without letting user know about it.

  • Selection event and Change events- most used events and how they sometimes call themselves and create problems. How to overcome.

  • How do we use Target key word in Events.

  • Does target keywords can be used outside Event windows. How we should understand the meaning of Target in Events while writing the program.

  • How to handle overlapping of Events - Sometime it happens that due to one change in event the other one fires immediately which changes the fate of your programe and can prove as fatal code for your data. What are the different approaches we can use in these cases.

  • Debugging of events - Is it F8 or something else. Importance of debugging the project before it gets ready to launch.

  • Use of Events in Excel Dashboard?

  • Live projects coming directly from students, Projects that will make anyone jumping in joy.

Who this course is for:
  • if you want to be a dynamic and powerful VBA programmer then you must visit this chapter.
  • If you want to take your dashboards to a new height using events skills then come and join with me.