What's your best tip that most people don't know about using VBA for Excel?

Asked by Last Modified  

Follow 2
Answer

Please enter your answer

You can use these tips while writing VBA Codes. 1. Use the application screen updating at the starting of the coded so that the user can see the final results directly instead of looking at the whole process of doing the activities which do not look good. 2. Using the Application.Display Alerts to...
read more
You can use these tips while writing VBA Codes. 1. Use the application screen updating at the starting of the coded so that the user can see the final results directly instead of looking at the whole process of doing the activities which do not look good. 2. Using the Application.Display Alerts to stop showing any alerts in between running the macro. 3. Using Application.Calculation to speed up your macro and calculate the values in the macro when needed. 4. Using Application.Status Bar which helps the user to know precisely at what process the macro is doing and how much time would it takes to complete the task. 5. Using Objects (Like-Worksheets, Range. With etc.) as much as you can, which helps you to speed up and improve the performance of the macro. 6. If you have a big macro code, then it is suggested to build in parts and always comment which helps to read the code and very quickly whenever changes required. 7. Declaring variable names which helps the coder to understand which variable is used for which purpose. VBA in Excel can be used in several MS Excel-based Automation use cases. For example, if you want to capture sales orders from users Computer using Excel, then you can use Sales Order capture tools - Excel-based VBA application. Hope this helps. read less
Comments

Related Questions

What are the 5 most essential excel tools to master?
tools? Is that right, is that what you wanna know? there is no such thing as tools inbuilt in excel. Tools are specifically designed for a set of people or a company for a specific purpose to be added...
Yashraj
0 0
6
I want to learn network simulator ns3 for my project.
Drop me message.. I have learn concepts of NS3. May be I can help you out.
Vineeth
1 0
8
How can I create a letter head on excel?
Select a cell for typing the Title, change the font size in Formatting tool bar, merge cells in formatting tool bar depending on the length of title.
Jitendra
How can I create an organization chart in MS Excel?
Best option would be smart art tools for creating an organisational chart.
Poojashree
0 0
5
How many columns can be created in MS Excel?
Hi Manisha, Default Columns in Excel updated versions like 200, 2010, 2013,....... are 16384 Columns , Starts from A-XFD
Manisha
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

What is a SQL join?
A SQL join is a Structured Query Language (SQL) instruction to combine data from two sets of data (e.g. two tables). Before we dive into the details of a SQL join, let’s briefly discuss what SQL...

Hidden Gems Of MS Excel - Sort (add Multiple Levels to Sort Data)
Please refer following dataset: You would know:- To Sort Month from Oldest → Newest OR Newest → OldestOR- To Sort Region from A → Z OR Z → AOR- To Sort Units Sold from Smallest →...

Excel Tip: Conditional Formatting To Highlight First Value Among Duplicates.
In Column “C”, I have product list and some of them are duplicates. My requirement is to format with background color of green for 1st found value among the duplicates. To solve this, I used...

Exploring Excel HLOOKUP Formula
Let's break down HLOOKUP in detail. What is HLOOKUP? HLOOKUP (Horizontal Lookup) is an Excel function that searches for a specific value in the first row of a table and returns a value...
G

Ganesh S.

0 0
0

Create a Grading in Excel using Formulas (All versions)
Topic: Applying Grading /Ranking in Excel (All versions Let’s Say you need to rate the Sales with some grade text like POOR, AVERAGE, GOOD and EXCELLENT Based on a range of values as mentioned...

Recommended Articles

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 >

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 >

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 >

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 >

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