Automation Fever

How to Show developer Tab || What is VB Editor in Excel VBA in Hindi https://www.youtube.com/watch?v=jHIoVFjXjxI If you are new in Excel Vba and you want write your first Macro. You will not able to find Developer Tab in your excel Ribbon. Because By default Developer Tab is hidden away in program's settings.You have to do some steps to show the developer tab in your ribbon. But before enabling the developer Tab. You should know what is a Developer Tab. Developer Tab :- Developer Tab has VBA properties and Tools which we use to write the Macro Code, to create the command button, to make the userforms, etc... If you are using Excel 13, Excel 10 or Excel 365. You have follow below steps to show developer Tab . Click on File Tab ---Click on Options --- Customize Ribbon ---- Check the checkbox in front of Developer Tab ---- And Click. But if you are using Excel 07, you have to do below steps :- Click on Office Button show left most corner of excel Window ---Excel Option

VBA Stands for Visual Basic for Applications. There are two words in VBA. Do you about both the words(Application & Software) ? Application :-Application is a program or group of programs designed to perform a task or activity for end user. Visual Basic :-Visual Basic is a programming language. The first version of Visual Basic launched By Microsoft in 1991. Vba is a language what help you to write code to automate the task of applications. Excel-VBA is designed by Microsoft in 1993. Don’t confuse VBA with VB (which stands for Visual Basic). VB is a programming language that lets you create standalone executable programs (.exe files). Although VBA and VB have a lot in common, but they are different. #AutomationFever #Automation #VbaIntro #VbaIntroduction #AboutVba #VbaHistory

Why Should Learn VBA? We discussed in this video the uses of Vba. What can be the role of Vba in the growth of career. Vba coding can save your lots of time. If you know conditional formatting, data-validation , text formulas, vlookup, pivot table. You should learn how to code in vba. #AutomationFever #Automation #ExcelVba #WhyShouldLearnVba #Macros #UsesOfVba #WhyShouldLearnExcelVBA