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...
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...
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...
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...
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...
A class is the formal definition of an object. The class is a template for the creation of the object during programming, and defines the properties ...
Start the Visual Basic editor. Select the desired project in the Project-window. Insert a new class module by selecting the menu Insert | Class Modu...
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.
