What are the things in VBA that learners get wrong?

Asked by Last Modified  

1 Answer

+1

Follow 1
Answer

Please enter your answer

Microsoft Certified Trainer

Great Question dear Sahil, your answer is based on the learner's way of learning. Some people learn VBA watching videos and website or reading books and most of this literature is provided by trainer and mentors. In the case when the learning is through self-learning and with the error and trial methods...
read more
Great Question dear Sahil, your answer is based on the learner's way of learning. Some people learn VBA watching videos and website or reading books and most of this literature is provided by trainer and mentors. In the case when the learning is through self-learning and with the error and trial methods without any trainer/coach then many things are not learned properly. Example of such learning will avoid using declaration, use of select properties unnecessarily, the absence of application properties like screenupdating/ display alerts making again false after use and many more. Hope you get some clarity and further you can connect me. All the best read less
Comments

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
Is MS Excel very easy to learn?
Yes it is easy application to learn
Kamal
0 0
6
Hello, I would like to attend training for getting updated with the latest features in MS PowerPoint, can you suggest best online coaching for this?
If you are staying in mumbai I can help you. I was corporate,trainer of Microsoft. I taught more than 5000 professionals on MS products. If you are interested you can contact me.
Naren
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
How to write macros in excel?
1) you record a macro 2) macro programming:- macro is type of a sub procedure to perform some task. sub is a keyword. the set of program statements you have to write between the two lines syntax:- sub macroname statements ----------- end sub
Vidyarajeev

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

Ask a Question

Related Lessons

Data Filtering In Excel
Filtering data in MS Excel refers to displaying only the rows that meet certain conditions (The other rows gets hidden). Using the store data, if you are interested in seeing data where Shoe Size is 36,...

VBA Function - RIGHT
RIGHT function in VBA returns the Specified number of characters from the end of a text string Syntax: Right(String,Length) Sub RIGHT_1() Dim mystring As String mystring = "Narendra Modi" MsgBox Right(mystring,...

VLOOKUP and LIST Creation Explained
.) This table is in the range A1:D4. You want to find the salary of employee with ID 102. Excel =VLOOKUP(102, A1:D4, 4, FALSE) 102: The Employee ID (your lookup_value). A1:D4: The table containing...
G

Ganesh S.

0 0
0

MS Project: Manual and Auto schedule tasks
Tasks can be scheduled in MS Project in two ways - manual scheduling and automatic scheduling. Manual scheduling gives the users control over how tasks are scheduled and on the other hand auto schedule...

Screen Cipping
Ms-Office from 2010 version gives you a wonderful tool called screen clipping, which is available in Word, Powerpoint and Excel whereby you can select any tiny portion of the picture you like and paste...

Recommended Articles

Microsoft Excel is an electronic spreadsheet tool which is commonly used for financial and statistical data processing. It has been developed by Microsoft and forms a major component of the widely used Microsoft Office. From individual users to the top IT companies, Excel is used worldwide. Excel is one of the most important...

Read full article >

Business Process outsourcing (BPO) services can be considered as a kind of outsourcing which involves subletting of specific functions associated with any business to a third party service provider. BPO is usually administered as a cost-saving procedure for functions which an organization needs but does not rely upon to...

Read full article >

Almost all of us, inside the pocket, bag or on the table have a mobile phone, out of which 90% of us have a smartphone. The technology is advancing rapidly. When it comes to mobile phones, people today want much more than just making phone calls and playing games on the go. People now want instant access to all their business...

Read full article >

Information technology consultancy or Information technology consulting is a specialized field in which one can set their focus on providing advisory services to business firms on finding ways to use innovations in information technology to further their business and meet the objectives of the business. Not only does...

Read full article >

Looking for MS Office Software Training ?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you