macro

How to add Developer Tab in excel

How to add Developer Tab in excel

The Developer Tab in excel is a very important tab to accomplish many tasks in excel. It contains Macro-related buttons, Add-ins, Controls, and XML. The Developer tab is not preloaded in excel.

How to load Developer tab:

Go to File >>Option

How to add Developer Tab in excel
Developer tab

Then Go to Customize Ribbon >> Check Developer button

Cutom ribbon
Custom Ribbon

A new option will be added in ribbon as a developer:

Developer ribbon
Developer ribbon

We can see for different blocks in developer tab which is very useful in report creating.

You can also read below article for more info.

https://www.excelcampus.com/vba/enable-developer-tab/

https://www.excel-easy.com/examples/developer-tab.htmlContinue Reading

VBA in Excel: What is VBA, How to use

VBA in Excel

VBA stands for Visual Basic Application. It is an event-driven programming language used by Microsoft for its applications. VBA helps in many way ways like creating an automation process of any activity that we do manually, creating user-defined functions, or any activity which is repetitive in nature. By using VBA in excel we can save time and resources.

How to use VBA in Excel

We can use it in two different ways either by using VBA editor or by recording Macro. The choice depends on the expertise and comfort level of the user.

Where is VBA in excel

To use VBA editor we need to open VBA editor either by pressing alt & F11 or go to … Continue Reading