UrbanPro
Login Ask & Answer Success Stories Paid Courses Free Classes Tuition & Classes Fees Write a Review All Categories Help Center
Post your Learning Need Signup as a Tutor
✕

Popular Cities

Bangalore

Hyderabad

Delhi

Mumbai

Chennai

Pune

Kolkata

Gurgaon

Ahmedabad

Jaipur

Noida

✕

Learn Microsoft Excel Training from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Book a Free Demo

Microsoft Excel > Learn Microsoft Excel Training > Is it necessary to have the knowledge of VB script...
✕

Search in

Is it necessary to have the knowledge of VB script for Excel Macro Training?

Asked by Last Modified  

40 Answers

Learn Microsoft Excel Training

Follow 2
Answer

Please enter your answer

Graphic / Web / CAD Freelance Designer and Faculty

Please make a correction, its not VB Script but Excel VBA that you need to learn. VB Script is different form Excel VBA even though they both are subset of VB (the same parent), Please google to know more. The knowledge of Excel VBA is required to learn 'Excel Macro'. You should know that the term 'Macro'...
read more
Please make a correction, its not VB Script but Excel VBA that you need to learn. VB Script is different form Excel VBA even though they both are subset of VB (the same parent), Please google to know more. The knowledge of Excel VBA is required to learn 'Excel Macro'. You should know that the term 'Macro' means code. So obviously 'Macro Training' means training to code. In Excel you can create macros by using the macro recorder or writing the code manually. Most of the times the macro recorder may not do everything for you exactly as you need. Sometimes you may be successful using macro without properly knowing it. it's something like searching for a unknown location in the darkness without a route map or somebody's help. You can choose to learn macro if there is a professional requirement or you have a craze towards learning it. Anyways Your question has the answer clearly VB Script or Excel VBA, make a choice yourself. Thanks read less
Comments
Dislike Bookmark

Not necessary. As many have mentioned, the beauty of Excel is that most of your work can be done without VBA. Use formula as extensively as possible. You can also use record macros to look how the VBA works. Take help from online forums or from people on this site. Happy to help
Comments
Dislike Bookmark

Tableau Certified Developer and Trainer with 10+ Years of experience trained 300+ students

Yes it is needed
Comments
Dislike Bookmark

Personalised training for your needs.

If you have fixed steps that you want to perform without changing yhe conditions of the process you do not need to know VB script. You can use inbuilt macro record function. However note that VB script is different from macro development. Macro development is referred to as VBA and not VB Script. ...
Comments
Dislike Bookmark

Hi Suma, "We all talk about it.... often which is less understood." goes the saying. It is and it is not. VBScript (VB with .Net) should be considered if you are doing computation across One Computer , not Sheet. You will need multiple DB calls and puts secured architecture, MultiThreading, more importantly...
read more
Hi Suma, "We all talk about it.... often which is less understood." goes the saying. It is and it is not. VBScript (VB with .Net) should be considered if you are doing computation across One Computer , not Sheet. You will need multiple DB calls and puts secured architecture, MultiThreading, more importantly services which should not be called from excel to start with. VBA on the other hand (People errornously confuse it with erstwhile Windows Application builder which is now VB in Microsoft Blend) is ABSOLUTELY ESSENTIAL if you are going all the way to learning Macros. Whether the Instructor likes to tell you or not Invoking Numerical methods/ custom Functions can help. Macros are a popular representation of a proceedure or Subroutine (SUB in VBA). If you look at the video posted, you can see how recording a Macro helps you in learning VBA, but has several limitations which can be corrected only in code.... Limitations overcoming which reduces likelihood of error. VB and .Net will be perhaps as costly to learn as much of advanced excel. So unless you are to build Windows applications beyond scope of spreadsheets, there's no need. You can rather spend time learning more mundane technologies, and can bypass the need of learning complex return types. Again if you are already into cross MS Office application programming including complex VBA, you might just take the leap. if you'd need guidance on Business applications on Excel, and I'd be happy to help. Regards, Subhrodip Sengupta Scintilaa Education Center. read less
Comments
Dislike Bookmark

Professional Tutor with 15 years of experience.

to record macros VB is not required ..But to alter or to built your own, programming skill is very much required
Comments
Dislike Bookmark

Excel Expert

It will be easy to understand, however necessity makes you learn everything quicker
Comments
Dislike Bookmark

ITs ot compulasary but if u have knowledge for VB scripts then its easier and faster to learn Excel macro. Please contact us smartnubss@gmail.com for more details
Comments
Dislike Bookmark

Post Graduate in Engg

VB script is not needed for writing macros-Prakash Shukla
Comments
Dislike Bookmark

Dedicate quality time and there is nothing that cannot be learned

Its not necessary..However you need to have a fair understanding of excel to get a hang of macros.
Comments
Dislike Bookmark

View 38 more Answers

Related Questions

What should I learn other than excel VBA training?
Excel VBA is a Very vast topic. Once you will start working on real life projects you will find your knowledge is always short. You can always learn VBA with Excel, Word, Powerpoint, Access, AutoCad, Soldiworks....
Vishal
How to use the h look up in excel worksheet ???
Horizontal lockup
Sandeep
What are the benefits of using Excel in business?
Excel is mostly and widely used tool of Microsoft for business purposes, to maintain data, to maintain records as well as to have efficient result through calculations. Excel provides a bunch of formulas...
Vijay
0 0
8
How do I rename a worksheet in MS Excel?
Double click the worksheet name, then replace the existing name with a new name and press the enter key
Dhanshri
1 0
7
What are some cool Microsoft Excel tricks?
Best thing which can help you on Excel is to be familiar with the functions available in excel. You can learn them by using F1 function key on your keyboard, while you open the excel window, it will open...
Shagufta
0 0
8

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

How to Insert a Pivot Table.
Let's learn how to Insert a Pivot Table.

Amey Vidvans

0 0
0
VBA Tip: Print Random Numbers In A Selected Range
Let’s say you want to print some random numbers in a selected range then you can use below Macro. Sub Print_Randomnumbers() Dim myrng As Range For Each myrng In Selection myrng.Value = Application.WorksheetFunction.Int(Rnd...

Karthik Dale

0 0
0
How to work fast while working on MS Excel?
Many people struggle to find out the way on how they can work faster while working on MS Excel/Access or VBA. let me share the tip for that. If you are new or working since long time on Excel/Access...

Anant Jain

0 0
0
What Is Power Query?
Power Query is an Excel add-in that can be used for data discovery, reshaping the data and combining data coming from different sources. Power Query is one of the Excel add-ins provided as part of Microsoft...

ITech Analytic Solutions

0 0
0
Arrange and View Multiple Worksheets at Once in Excel
Arrange and View Multiple Worksheets at Once in Excel This feature allows you to view multiple worksheets at once from the same workbook at the same time. You need to follow beneath simple...

Vishesh Golya

0 0
1

Recommended Articles

Why Should you Learn Microsoft Office

Microsoft Office is a very popular tool amongst students and C-Suite. Today, approximately 1.2 billion people across 140 countries use the office programme. It is used at home, schools and offices on a daily basis for organizing, handling and presenting data and information. Microsoft Office Suite offers programs that can...

Read full article >

What is Applications Engineering all about?

Applications engineering is a hot trend in the current IT market.  An applications engineer is responsible for designing and application of technology products relating to various aspects of computing. To accomplish this, he/she has to work collaboratively with the company’s manufacturing, marketing, sales, and customer...

Read full article >

8 Hottest IT Careers of 2014!

Whether it was the Internet Era of 90s or the Big Data Era of today, Information Technology (IT) has given birth to several lucrative career options for many. Though there will not be a “significant" increase in demand for IT professionals in 2014 as compared to 2013, a “steady” demand for IT professionals is rest assured...

Read full article >

Top 5 Skills Every Software Developer Must have

Software Development has been one of the most popular career trends since years. The reason behind this is the fact that software are being used almost everywhere today.  In all of our lives, from the morning’s alarm clock to the coffee maker, car, mobile phone, computer, ATM and in almost everything we use in our daily...

Read full article >

Find Microsoft Excel Training classes near you
Microsoft Excel Training classes in Delhi
Microsoft Excel Training classes in Bangalore
Microsoft Excel Training classes in Mumbai
Microsoft Excel Training classes in Hyderabad
Microsoft Excel Training classes in Pune
Microsoft Excel Training classes in Chennai
Microsoft Excel Training classes in Kolkata
Microsoft Excel Training classes in Gurgaon
Microsoft Excel Training classes in Noida
Microsoft Excel Training classes in Ghaziabad

Looking for Microsoft Excel Training classes?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you
X

Looking for Microsoft Excel Training Classes?

The best tutors for Microsoft Excel Training Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn Microsoft Excel Training with the Best Tutors

The best Tutors for Microsoft Excel Training Classes are on UrbanPro

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more

ThinkVidya Learning Pvt Ltd © 2010-2024All Rights Reserved