What is VBA Immediate Window about?

Asked by Last Modified  

1 Answer

+1

Follow 1
Answer

Please enter your answer

Microsoft Certified Trainer

Dear Geetanjali, the actual purpose of the immediate window is to test a line of code and check its result. Some time in VBA we apply a line of code based on logic/past experience but not sure of its outcome. In that case, I will not write a sub procedure to test that code rather I will use immediate...
read more
Dear Geetanjali, the actual purpose of the immediate window is to test a line of code and check its result. Some time in VBA we apply a line of code based on logic/past experience but not sure of its outcome. In that case, I will not write a sub procedureto test that code rather I will use immediate window. Ctrl G is a shortcut key to open it, hope you get some idea. All the best and take care :) read less
Comments

Related Questions

How do I type new line inside a single cell? I don't want to go to another cell but there should be a new line inside 1 cell. Please help.
You can type Alt+Enter, in case you wanted word wrap, then goto the Home Tab, Alignment group and select Word Wrap otion
Arjun
What are some cool Microsoft Excel tricks?
there are 1000 of tricks that can be done in excel from basic to complex. but most awesome trick is to play old dosky games in excel, remember the child hood games like mario, boomerman , contra...
Shagufta
0 0
8
Should beginners learn excel VBA training online?
Hi Jayant, learning online should always be your second option. I am sure, the place where you live, there might be some coaching classes, tutors available who can teach you personally. This way, you...
Jayant
What is the fee for advance excel course?
It's depend how advanced excel you want to learn, only advanced 2k, Micro with vba 5k
Prabir

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

Ask a Question

Related Lessons

Sparklines
Sometimes you may want to analyse and view trends in your data without creating an entire chart. Sparklines are miniature charts that fit into a single cell. A Sparkline is a tiny chart in a worksheet...

Pivot table - Transform numbers in calculated field
How to convert the absolute numbers in pivot table into Lakhs, Millions, Trillions without adding a spare column in the data source. Name the field in the Calculated field and apply the formula by Double-clicking...

10 Best Job Interview Tips for Jobseekers
10 Best Job Interview Tips for Jobseekers:- 1. Conduct Research on the Employer, Hiring Manager, and Job Opportunity2. Review Common Interview Questions and Prepare Your Responses3. Dress for Success4....

What is Big Data and Why Do Organizations Need It?
Big data is a term that describes the large volume of data – both structured and unstructured – that inundates a business on a day-to-day basis. But it’s not the amount of data that’s...

What is a Dashboard?
Introduction There are many different ideas of what a dashboard is. This article will clearly define it along with other presentation tools. In article, What is BI? - A Business Intelligence Primer, it...

Recommended Articles

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 >

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 >

Hadoop is a framework which has been developed for organizing and analysing big chunks of data for a business. Suppose you have a file larger than your system’s storage capacity and you can’t store it. Hadoop helps in storing bigger files than what could be stored on one particular server. You can therefore store very,...

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