Pricing
Easy to maintain and your Excel still works as is. Your first app is 2 minutes away. We help you get started. Build on your existing skills and models in Excel. Even beginners can create sophisticated web, iOS or Android applications. Share your app with everybody, or restrict access - based. Microsoft Excel Mobile is the best app for reviewing, updating, and creating spreadsheets on Windows phones and tablets (with a screen size of 10.1 inches or smaller).On January 12, 2021 this app will reach End of Support on phones using Windows 10 Mobile. In this article, we will learn how to create and use the Application Event in Excel VBA in a few easy steps. Step 1: Create an Event Object in A Class Module. To create an event object, we need to use the class module. Insert a class module. Name it as you want. I named it MyAppEvents. Define an event variable of Application type with keyword. Creating an Excel Application from VB.Net Let's start with creating a Window Forms Application by following the following steps in Microsoft Visual Studio: File → New Project → Windows Forms Applications Finally, select OK, Microsoft Visual Studio creates your project and displays following Form1. Insert a Button control Button1 in the form. Dim xlApp as Excel.Application Set xlApp = New Excel.Application 'Early Binding Set xlApp = CreateObject ('Excel.Application') 'Late Binding Do not define (dim) inside a loop, however you can instantiate (Set) the same object as many times as you want.
Select your location
- Trial
Try out all standard features of Molnify free of charge for one month.
Price per MonthFreefor one month - Standard
Create powerful applications and share them with the world.
Price per Month2 000 SEKper app - Premium
Sophisticated applications with integration to APIs, databases, emailing, etc.
Price per Month5 000 SEKper app - Enterprise
On-premise hosting, unlimited number of applications and more.
Price per MonthContact Usfor price estimates
- Trial
Try out all standard features of Molnify free of charge for one month.
Price per MonthFreefor one month - Standard
Create powerful applications and share them with the world.
Price per Month200 EURper app - Premium
Sophisticated applications with integration to APIs, databases, emailing, etc.
Price per Month500 EURper app - Enterprise
On-premise hosting, unlimited number of applications and more.
Price per MonthContact Usfor price estimates
- Trial
Try out all standard features of Molnify free of charge for one month.
Price per MonthFreefor one month - Standard
Create powerful applications and share them with the world.
Price per Month230 USDper app - Premium
Sophisticated applications with integration to APIs, databases, emailing, etc.
Price per Month575 USDper app - Enterprise
On-premise hosting, unlimited number of applications and more.
Price per MonthContact Usfor price estimates
Key Features
- No Programming Skills
No coding skills are needed. Just color your input cells green, your output cells red and you're good to go!
- Extensive Function Support
Support for all commonly used Excel functions, such as SUM, COUNTIF, IF/ELSE, SUMPRODUCT, CORREL and many more.
- Looks Great on Any Device
Molnify is designed to look awesome on computers, smartphones and tablets. See example here.
- Secure
All communication between clients and the Molnify back end is secure and encrypted.
- Integration
Integrates with third party services via XML and JSON, with no extra coding than what's in the Excel file.
The Latest Improvements
- Extensive Function Support
- Secure
The Application level events work on the entire application(Excel in this reference). But activating the application event is not as easy as creating Workbook or Worksheet Events. But I assure you that it is not that tricky as well. In this article, we will learn how to create and use the Application Event in Excel VBA in a few easy steps.
Step 1: Create an Event Object in A Class Module
To create an event object, we need to use the class module.
- Insert a class module. Name it as you want. I named it MyAppEvents.
- Define an event variable of Application type with keyword WithEvents.
- Initialize this event in class_initialize() subroutine.
From the drop-down on the left, select class. Afterward, on the top-right drop-down, select initialize. - Now define the events you want to use. From the top-left drop-down, select the event object. All the available event handling procedures will be available to you in the top-right drop-down menu. Select whichever you require and define what you want to do when that event triggers.
I use the SheetActivate Event. Whenever a user will switch among sheets of any open workbook, it will show the name of the workbook and the sheet user has selected.
You can define as many events you want to define here.
The events won't start working immediately. This was the first step. Since it is a class module, we need to create an object of it to make events activate.
Now we only need to start these events from a normal subroutine.
Step2: Create an Event Starter Subroutine in Normal Module
Now we have an event class. We just need to create an object of that class and initialize it. Once we run this subroutine, all the defined events in the event class will start working.
- Insert a normal module.
- Define a variable of the class you have created.
- Initialize it in a subroutine. You can name it as you want.
- Run this code using the F5 key. Optionally, you can assign this macro to button on the worksheet if you want to start the events from the worksheet.
And it is done. Now whenever you will switch sheets, a message box will appear with the name of the workbook and the sheet, as long as the code containing workbook is open.
Was it tough? I don't think so. Let me know what you think in the comment section below.
Switching VBA Application Events On and Off
Once you run the macro in the normal module, it will trigger always until you close the workbook that contains the events. But you may want them to switch them on and off at your will. There are two ways to do this.
- Nullify the Event Object
- Set EnableEvents to False
1. Nullifying The Event Object
In a separate subroutine, set the event object to Nothing
Once you run this code, the events will stop working. You can put it in a button on the worksheet to stop the events. Now you will have two buttons to start and stop these specific events. It will just stop events created by the AppE object.
2. Set EnableEvents to False
The second method is to disable the events. To make all events uncatchable we set the EnableEvents property of Application class to False.
The above code will disable all the events. Even the default excel events. They will not work until you start them again. Even if you run the StartEvents() subroutine (above), the event will not work. To make all events work again, you will have to set EnableEvents property again to True.
So if you want your events to work every time you start the events, add this line of code in the sub.
Starting Custome Application Events every time Workbook Opened
If you are developing a tool for end-user, you may want the events to work automatically. In that case, you can put the event starter in the Workbook object with Workbook_open() event, instead of in a normal module. This will make your event object initialized as soon as you open the workbook that contains the events.
So yeah guys, this how you can use the application event in excel. Let me know if this was explanatory enough and helped you understand Application-Level Events in Excel VBA in the comments section below. If you have something to add to this, write that down too. You can ask your queries related to this article or any other excel VBA related topic in the comments section below.
Download the working file below:
Related Articles:
Is Excel An Application Software
The Events in Excel VBA | There are seven types of Events in Excel. Each event deals in different scope. Application Event deals with on workbook level. Workbook on sheets level. Worksheet Event on Range level.
Was it tough? I don't think so. Let me know what you think in the comment section below.
Switching VBA Application Events On and Off
Once you run the macro in the normal module, it will trigger always until you close the workbook that contains the events. But you may want them to switch them on and off at your will. There are two ways to do this.
- Nullify the Event Object
- Set EnableEvents to False
1. Nullifying The Event Object
In a separate subroutine, set the event object to Nothing
Once you run this code, the events will stop working. You can put it in a button on the worksheet to stop the events. Now you will have two buttons to start and stop these specific events. It will just stop events created by the AppE object.
2. Set EnableEvents to False
The second method is to disable the events. To make all events uncatchable we set the EnableEvents property of Application class to False.
The above code will disable all the events. Even the default excel events. They will not work until you start them again. Even if you run the StartEvents() subroutine (above), the event will not work. To make all events work again, you will have to set EnableEvents property again to True.
So if you want your events to work every time you start the events, add this line of code in the sub.
Starting Custome Application Events every time Workbook Opened
If you are developing a tool for end-user, you may want the events to work automatically. In that case, you can put the event starter in the Workbook object with Workbook_open() event, instead of in a normal module. This will make your event object initialized as soon as you open the workbook that contains the events.
So yeah guys, this how you can use the application event in excel. Let me know if this was explanatory enough and helped you understand Application-Level Events in Excel VBA in the comments section below. If you have something to add to this, write that down too. You can ask your queries related to this article or any other excel VBA related topic in the comments section below.
Download the working file below:
Related Articles:
Is Excel An Application Software
The Events in Excel VBA | There are seven types of Events in Excel. Each event deals in different scope. Application Event deals with on workbook level. Workbook on sheets level. Worksheet Event on Range level.
The Worksheet Events in Excel VBA|The worksheet event are really useful when you want your macros run when a specified event occurs on the sheet.
Workbook events using VBA in Microsoft Excel | The workbook events work on the entire workbook. Since all the sheets are part of the workbook, these events work on them too.
Prevent an automacro/eventmacro executes using VBA in Microsoft Excel| To prevent the run of auto_open macro use the shift key.
Chart object events using VBA in Microsoft Excel| The Charts are complex objects and there are several components that you attached to them. To make the Chart Events we use the Class module.
Popular Articles:
Create An Excel Applications
50 Excel Shortcuts to Increase Your Productivity | Get faster at your task. These 50 shortcuts will make your work even faster on Excel.
The VLOOKUP Function in Excel | This is one of the most used and popular functions of excel that is used to lookup value from different ranges and sheets.
COUNTIF in Excel 2016 | Count values with conditions using this amazing function. You don't need to filter your data to count specific value. Countif function is essential to prepare your dashboard.
Excel Application Free Download
How to Use SUMIF Function in Excel | This is another dashboard essential function. This helps you sum up values on specific conditions.
