UrbanPro

Location Set your Location

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 is the difference between an MS word, an MS Excel, and an MS PowerPoint?
All three are applications of Microsoft office. MS Word is a word processing application, where you can type anything you want, primarily used for creating documents, brochures etc. MS Excel is a spreadsheet...
Krishna
0 0
5
How do I delete a worksheet in MS Excel?
There are many ways to do it. You can also do it from the home tab. Please refer the image attached.
Khushbu
Which course can be related to MIS executives, Since I have past experience in data base related job I want to try for MIS profile. So kindly suggest me which course suits me for the same profile.
Hi, You can check our course - Analyse and Visualize with Excel. Excel is the most popular tools used by analyst and MIS manager for getting insights from data. Create powerful Dashboards to enable data driven decision making.
Martin
What is VBA and what is its importance?
vba is visual basic for application. it is used to automate the task and make user define formula.
Shagufta
0 0
5
Linear Programming in Excel ?? Can someone can solve just 1 question of Linear Programming in Excel ?? I am ready to pay. Thanks
I am ready to work with you. It has to be 50-50.
Garry
0 0
5

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

Ask a Question

Related Lessons

VBA Function - INSTR
INSTR works similar to FIND function in Excel. INSTR search for specific text in a given text and returns the position number of what you are searching for. Syntax: InStr( , string, searchingfor, ) Sub...

Karthik Dale

0 0
0
Basic EXCEL Tips
Learn Use of MAX function in EXCEL: Penalty of Rs. 2% or Minimum Rs. 100 Amount Penalty Formula Rs 1000 200 +MAX(1000*2%,100) Rs 400 100 +MAX(400*2%,100)

Kshitij Agrawal

0 0
0
MS Excel Tips
If you want to do a save as on MS Excel Workbook, use the shortcut key F12 and then select the location and click save
R

Rashmi Raj

0 0
0
Remove gridline on active sheet
If you want to remove gridline on your active work sheet then follow below path Go to Ribbon click on View tab then uncheck gridline check box as shown in picture

Shashank Maheshwari

1 0
0
What are the function categories on Excel?
Function Categories There are many categories of functions in Excel. Each category has specific functions that pertain to that category. Financial: Performs common business calculations including accounting...

Talent Hub Training Institute

0 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 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