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

Himaghiri Thanayan N

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

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

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

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

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

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

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

Post Graduate in Engg

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

View 38 more Answers

Related Questions

can i teach
For teaching two things are must 1) you must have sound knowledge of the topic 2) then you must know the art of teaching. You should teach in a such a way that you are able to make people understand...
Abdul

What is use of VBA? Can you explain it?
Hi Venkat, As per my opinion and experience, we are using VBA for reducing the repetitive task in excel. For example: Suppose every day you are preparing an attendance tracker in which you will mark present/absent...
Venkat
0 0
5
Is MS Excel very easy to learn?
Yes it is easy application to learn
Kamal
0 0
6

What is the use of Data validation commond. can you demonstare the example in common life?
The point of data validation is to pick the list in a drop down fashion. It will ease your work by allowing you to select the entries from the drop down rather than you writing for it. It saves a lot of time when it comes to large dataset.
Anil
0 0
5
Is Excel online coaching much costlier than excel coaching classes?
You'll find numerous sites offering free training/material online. You may also learn directly from Microsoft excel product help. Join classes only if you need step by step guidance and monitoring
Radha

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

Ask a Question

Related Lessons

Cell Properties
G

Gagan G.

0 0
0
Slicer in Excel
Have you every tried Slicer option in Excel? There are lot many features in excel which go unnoticed even if they are visibleAs you know, one of the powerful tool in excel is Pivot table which summarizes...
R

Rakesh R

2 0
1
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
Hidden Gems of MS Excel - Reapply Filter
Q) How does Reapply help? Or, when could I use Reapply?A) e.g. Please refer following screenshot: You are Analysing a Dataset.You have applied Filter on Date Column, to focus on April month entries.You...

Ankur Sharma

0 0
0
Top 5 Excel Tips Every Beginner Should Know
Top 5 Excel Tips for Absolute Beginners Getting started with Excel doesn’t have to be tricky! Here are 5 tips that will make your journey much easier: AutoSum Magic: Want to quickly add up...

Roopkumar Murali

1 0
0

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 Bangalore
Microsoft Excel Training classes in Delhi
Microsoft Excel Training classes in Mumbai
Microsoft Excel Training classes in Hyderabad
Microsoft Excel Training classes in Chennai
Microsoft Excel Training classes in Pune
Microsoft Excel Training classes in Gurgaon
Microsoft Excel Training classes in Noida
Microsoft Excel Training classes in Kolkata
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