Set up conditional formatting for an area using VBA in Microsoft Excel

In this article, we will create a macro to apply conditional formatting in the selected area. We have used random numbers as sample data to demonstra...

Build an Excel Add-In in Microsoft Excel

  Excel Add-Ins An Excel Add-In is a file (usually with an .xla or .xlam extension) that Excel can load when it starts up. The file contain...

Format data with custom number formats using VBA in Microsoft Excel

  In this article, we will create a macro to format the given data in the desired custom number format using VBA. Raw data for this example con...

Worksheet events using VBA in Microsoft Excel

Events for the worksheet object occurs when a worksheet is activated or the user changes the content of a cell. Events in worksheets are activated by...

How To Use Workbook Events in VBA

You may want to run your macro/VBA snippet when a specific workbook is selected, A sheet in the workbook is selected, cell changes its value, when a d...

Prevent that an automacro/eventmacro executes using VBA in Microsoft Excel

If you wish to open a workbook without running an Auto_Open-macro, you can do this by holding the Shift-key down when you open the file. If the wo...

Embedded Chart Events Using VBA in Excel

Using Chart sheet events(worksheet especially for charts) is fairly simple. But when it comes to using events on embedded charts, It is not that simpl...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube