Excel Workbook_BeforeClose Event
Excel predefines some popular actions that you would do on different Objects (worksheet, workbook, button, etc), those actions are called Event. For example, activating a worksheet is an Event, closing a workbook is an Event, clicking on a button is an event. Each Object has its own list of Events, Workbook has a list of Events (e.g. close workbook, open workbook), worksheet has a list of Events (e.g. activate worksheet, edit a Cell).
If you perform an Event...
Read More
VBA
Excel Workbook.Deactivate Event
Excel Workbook_Deactivate Event
Excel predefines some popular actions that you would do on different Objects (worksheet, workbook, button, etc), those actions are called Event. For example, activating a worksheet is an Event, closing a workbook is an Event, clicking on a button is an event. Each Object has its own list of Events, Workbook has a list of Events (e.g. close workbook, open workbook), worksheet has a list of Events (e.g. activate worksheet, edit a Cell).
If you perform an Event,...
Read More
Excel Workbook.Activate Event
Excel Workbook_Activate Event
Excel predefines some popular actions that you would do on different Objects (worksheet, workbook, button, etc), those actions are called Event. For example, activating a worksheet is an Event, closing a workbook is an Event, clicking on a button is an event. Each Object has its own list of Events, Workbook has a list of Events (e.g. close workbook, open workbook), worksheet has a list of Events (e.g. activate worksheet, edit a Cell).
If you perform an Event, s...
Read More
Function, Sub, Method, Property Differences
This tutorial explains differences among Function, Sub, Method, Property Excel / Access VBA.
You may also want to read:
Difference between Dim and Set
Excel VBA Option Explicit to force declaration of variables
Difference between ByRef ByVal
Function, Sub, Method, Property Differences
In my blog, I have categorized different VBA topics by their properties. If you don't understand Function, Sub, Method, Property Differences, you will find my tips confusing and difficult to use. Thos...
Read More
Excel Find Function
This Excel tutorial explains how to use Excel FIND Function for Excel worksheet, and also explains the differences between INSTR and SEARCH function.
You may also want to read:
Extract text in brackets
Remove text in brackets
Excel Find Function
Excel Find function is used to search a substring (part of the string) within a string and return the position of the first occurrence, note that Excel Find function is case sensitive. Excel Search function is very similar to Find functi...
Read More
Excel Search Function
This Excel tutorial explains the Excel Search Function for Excel worksheet, and also explains the differences between INSTR and FIND function.
Excel Search Function
Excel Search function allows Wildcard to search a substring (part of the string) within a string and return the position of the first occurrence. Excel Search Function is not case sensitive, you should consider using Excel FIND Function for case sensitive comparison, but FIND Function cannot use Wildcard.
For example, ...
Read More
Change Pivot Table Layout using VBA
Change Pivot Table Layout, why?
To illustrate why we want to change Pivot Table Layout, lets see the below example.
Assume that we use the following data to create a Pivot Table. We want to show the total summary, group by Department, Empl ID.
Excel 2003 - Tabular layout
Pivot Table layout is called "Tabular", where each grouping is in one column, and the subtotal is at the bottom of each group.
Excel 2007 and onwards - Compact layout
By default, Pivot Table layout is called ...
Read More
Create Pivot Table using Excel VBA
This Excel tutorial explains how to create Pivot Table using Excel VBA, set Print Area for Pivot Table
Create Pivot Table using Excel VBA
Create Pivot Table using Excel VBA is very straight forward and easy to use. If you don't understand any Object or Property that VBA Pivot Table uses, simply use "Record Macro" function to do recording to see the underlying VBA code behind each action, such as create Pivot Table, change Pivot Table Fields, select Critera, delete Pivot Table, etc.
In this ...
Read More
Writing your first Excel Macro by recording Macro
This Excel tutorial guides you to create your first Excel Macro by Record Macro function, and explain how to modify Macro in Visual Basic Editor
You may also want to read:
Create Excel Add-in and add in Ribbon
Excel Record Macro
Writing your first Excel Macro by recording Macro, why?
First of all, you should face the fact that you cannot know everything. You can use Microsoft Windows does not mean you can write your own Windows. Even if you are a Windows Administrator, it only means...
Read More
Excel Record Macro
What is Macro and what is Excel Record Macro function?
Macro is a set of actions that is intended to be repeating all over again. Macro is not a word just for Excel, you can find many other software help users record a set of actions for Windows or even for specific games. The first Macro I used was EZ Macro about 15 years ago, which helps me repeat a set of actions in an online game endlessly in order to get my skill points up. Today I still use keyboard and mouse that can record Macro...
Read More