Excel VBA: A Comprehensive Beginner's Guide to Learn Excel VBA Step by Step by Dustin Adams

Author:Dustin Adams [Adams, Dustin]
Language: eng
Format: azw3, epub
Published: 2020-05-20T16:00:00+00:00

The construct Enum ... End Enum is used to create an enum. Enumerations may only have integral values such as byte, long, long integer.

In addition to the system defined enumerations, you’re free to define your own enumerations.

To access an enumeration value, for example, vbOKOnly , you’d write the following:

vbMsgBoxStyle.vbOKOnly

This returns the value zero. However, you’re free to use it as 0 should you wish to.

Events

An event denotes an occurrence, such as the click of a button in the program. Other examples are opening a new workbook, inserting a new worksheet and double-clicking a cell. You may want to perform a specific action when a given event occurs. For example, you may want to validate a user’s input when they hit enter after editing

Events gained popularity with the advent of graphical user interfaces, where a user can possibly perform one of several actions on the screen. It is important to know what action the user has performed so that the program can respond appropriately. This process of responding to the occurrence of an event is called event handling. To handle an event, you need to subscribe to it so that when the event occurs, you get a notification and you can then take any action that you desire in response. In VBA, subscribing to an event is implied once you write a handler for that event.

Event Handlers

An events handler is a special procedure that executes when an event occurs. The occurrence of the event automatically calls the event handler, which in turn may call other procedures required for it to complete the desired action. In code, the event handler is a subroutine that has a special structure to differentiate it from other procedures. This is because the event handling mechanism in VBA is based on a naming convention. An event handler has the following structure:

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.