How to Open Excel VBA Editor in Microsoft Excel

How to Open Excel VBA Editor in Microsoft Excel

Excel VBA is a powerful tool which enables the automation of tasks in Excel. It can be used to automate many repetitive tasks along with more complex applications. Having access to the VBA editor lets you write your own VBA code or review recorded macros. This quick tip guide shows you how to open the Excel Visual Basic Editor (aka Excel VBA Editor) and get started with VBA programming in Excel. 

you can open the visual basic editor in Microsoft excel very easily. just follow below steps.

You can also open VBA in Excel using Alt + F11 keyboard shortcut.

Click the visual basic button on the developer tab.

If the Developer tab is not present, go to File -> Options -> customize ribbon and tick Developer.

you have done good choice for choosing editing as a career. so  what it is ?

VBA Editor is a tool in Microsoft ms Excel hidden in tools inside which only editors and developers knows. it is not used in day to day life use in excel and most of the people don't even now about it.

so it is a tool to make your daily life easy. it is a tool to write functions and codes to automate your day to day tasks. just think you do certain activity in excel on daily basis which is same on daily basis. just think if it can be automated then here comes the vba editor to do your job.

if you want to know how to enable developer mode in excel and use vba editor then read my another post. link down below:

https://basicknowledge93.blogspot.com/2020/03/how-to-enable-developer-mode.html

so to start vba you just need to follow above steps and start vba editor.

in vba editor you will find interface as mentioned blow in the screenshot.

project pane vba editor

as shown above this interface is called project panel. in this panel you will find all the codes you have written and all the macros were recorded in the shape of modules.

to insert a new module you need to go to insert and select module ( the second option as shown below.

Insert a Module

the other way to automate your work if you are not familiar about coding then just start a macro while doing your work. and after macro is recorded review the code of the macro and edit as per your need.

start a macro

lets start your vba editing just by typing below mentioned code in vbe excel editor.

Sub showMessage()

        MsgBox "Hello World"

End Sub

Hello World

so that's all for today hope you have enjoyed the my post on vba editor. for more tips and tricks on excel knowledge and other software knowledge. plz do subscribe and enjoy.

Thanks

How To Enable Developer Mode Option in Excel For Beginners

How To Enable Developer Mode Option in Excel For Beginners : - Hello Everyone hope u all doing well. today we will learn how to enable the developer mode option in Microsoft MS Excel. most of the people in today's world knows how to work on computer software and they do the daily basis tasks very easily. but some time when you are in need some little things got very hard to understand and people have face difficulties finding little options in software. so today we will learn how you can enable developer mode options in Microsoft ms excel. so lets begin.

so there are some steps you can follow to enable the developer mode in excel are as follows : - 

1. so first of all we need to click on the file menu in ms excel.
2. then select the options.

         

Enable Developer Mode in Excel

     3. After selecting the options go to the Customize Ribbon Tab
     4. and go to the customize the ribbon option and tick mark the developer option.
             
   

Enable Developer Mode in Excel

    5. after doing this you will be able to see the Developer Options in the main menu bar. as shown              below.

Enable Developer Mode in Excel

so this is the easiest and simplest method to Enable the Developer Option in Microsoft MS Excel.

that's all for today. hope you liked this post . Please do subscribe and do visit my blog for most software tips.

Thanks a lot.😊