Shweta Sehgal Jan 24, 2018 No Comments
For those who have done a lot of MS Excel surely must have come across the concept of VBA macros. No wonder to many of us it is still a question as to why one shall need VBA when one has access to loads of inbuilt functions of office tools.
Often our task involves mundane and repetitive steps and use of Excel, most widely used application of Microsoft, can frustrate you. It is at this point when the application of VBA comes handy and your life seems more blissful!
VBA stands for Visual Basic for Applications is a BASIC based event driven programming language predominantly used at the backend of MS office tools. The VBA codes or macros are written in modules of VBA editor. The macros help you to automate your Excel work like calculations, generating reports, graphing charts etc. and by doing so saves your time and energy while expanding the power of Excel at the same time. Moreover it is an easy and flexible language using simple algorithms.
As a beginner hit the codes in your VBA editor and wait to see its miracle!
Open any of the Microsoft Office tools and press Alt+F11. You land up on the VBA editor and this where you write your programs. Every program in VBA starts with SUB and ends with END SUB.
Sub republic ()
Dim Wish As String
Wish = InputBox (“It’s 26th Jan!”)
MsgBox “A very Happy Republic Day from Team Ivy”
Run the macro by just pressing F5.
Happy Republic Day! Happy VBA – ing!
Ivy Pro School (Ivy) is a pioneer in Big Data Analytics, Machine Learning and Data Visualisation using Advanced Excel, VBA, SQL. Ranked among the Top 10 Big data Analytics institutes in the country for the last 4 years, Ivy has trained more than 15000 professions. Ivy Professional School is the official learning partner to large Analytics companies like Genpact, HSBC, ITC. Ivy’s Big Data Analytics Certification course in Bangalore, Kolkata and New Delhi is offered to students as a classroom session. In other cities in India it is available online.