Debug VBA Macros

You may have heard of the technique called debugging before. With this technique you can find errors in your Excel VBA code before you execute the code. To show you how to debug a macro, execute the following steps. 1. [...]

VBA Macros Error

Unfortunately, not everything goes right the first time. Excel VBA will sometimes give you a macro error saying that something isn’t programmed correctly. There are too many Excel Visual Basic errors to explain them all at this stage. However, here [...]

VBA MsgBox

The Excel VBA MsgBox (message box) is a dialog box you can use in Excel VBA to display information to the users of your program. Below you can find three easy examples on how to create a MsgBox in Excel [...]

Create a Macro in Excel 2007

Turn on the Developer Tab    |   Create a command button    |   Create and Assign the Macro To create a macro in Excel 2007, you have to turn on the Developer tab. Next, you can create a macro which will be executed after clicking on [...]

Create a Macro in Excel 2010

 Turn on the Developer Tab    |   Create a command button    |   Create and Assign the Macro To create a macro in Excel 2010, you have to turn on the Developer tab. Next, you can create a macro which will be executed after clicking on [...]

Macro Comments

A macro comment is a piece of text in a macro which will not be executed by Excel VBA. It is only there to provide you information about the macro. To let Excel VBA know that it is a comment, [...]

Objects, Properties & Methods

Excel VBA Property    |   Excel VBA Method    |   See all the properties and methods of an Object In Excel VBA, objects, properties and methods are connected with a dot. Properties are something which an object has (they describe the object), while methods do something [...]

Macro Security in Excel 2003

It is important to know that macro may contains virus and worms. So in order to work safely you had better to follow the steps and advices provided in this article and make sure that your macro security settings are [...]

VBA Macro Security in Excel 2010 / 2007

To set up an excel macro security settings in Excel 2010 or in Excel 2007, folow the steps below 1. Click on Macro Security.   2. Here you have four options. The first option will disable all macros. The second [...]

Remove Duplicates Excel VBA Macro

Description : Remove Duplicates from Excel is designed for searching and processing duplicated cells in Excel tables. Find and remove duplicates in Excel easily with this Excel add-in. Program key functions: – Two search modes: across rows or columns – [...]

Microsoft Ribbon Hero

Description : Ribbon Hero is a *gasp* game for Office 2007 and Office 2010 (Word, PowerPoint, Excel and now OneNote!) designed to help you boost your Office skills and knowledge. If you feel Office can do a lot more than [...]

Tree Plan Decision Tree VBA Add-In

Description : TreePlan Decision Tree Add-In TreePlan helps you build a decision tree diagram in an Excel worksheet using dialog boxes. Decision trees are useful for analyzing sequential decision problems under uncertainty. Your decision tree model may include various controllable [...]

SensIt Sensitivity Analysis VBA Add-In

Description : TreePlan Decision Tree Add-In SensIt Sensitivity Analysis Add-In SensIt performs sensitivity analysis on your worksheet what-if model and creates simple plots, spider charts, and tornado charts. In a decision situation, sensitivity analysis helps you determine which of your [...]

RiskSim Monte Carlo Simulation VBA Add-In

Details : RiskSim Monte Carlo Simulation Add-In RiskSim provides random number generator functions as inputs for your model, automates Monte Carlo simulation, and creates charts. Your spreadsheet model may include various uncontrollable uncertainties as input assumptions (e.g., demand for a [...]