What if you do not have internet ??

.

Wait.. this is supposed to be an Excel Blog.. right? Then why such article here? Am I going to discuss about this biggest problem of the World 😉 i.e. Internet Not Working?? Or Have I got some excel macro which will fix your Internet Connection problem. Or an Excel Macro to boost your WiFi Signal??

Internet Connection Not Working

Internet Connection Not Working

Unfortunately, I have got none of what mentioned above. But I am definitely going to explain you something which will help you finding help on excel VBA even when there is no Internet. And I am not talking about your e-book which you downloaded last weekend or not even the Book you bought from your favorite book shop near your place. Here I am talking about Microsoft Excel offline help which is available in your own Excel workbook. This is just a click away. If you really want to start learning VBA and want to become expert, I would recommend you to read the documentation provided by Microsoft as well. They are excellent.

How to Read Microsoft Excel product Offline Help

1. Excel Help for all the non-VBA stuff

When you are on Active Worksheet and PRESS F1 There will be a Help Window opened like below. This help windows will not have any documentation about VBA.

Microsoft Excel Offline Help

Microsoft Excel Offline Help

From the above Table of Content, you will see that it will not have documentation about Excel VBA. This will have all the documentation about excel worksheet, Macro, Data Chart etc.

2. Excel Help for VBA

To get help about VBA, you first need to go to VBE window by pressing ALT+F11. Once you are on VBE window, press F1. This time same kind of Help window will appear but if you can see the contents are related to VBA only.

VBA - Help Offline

VBA – Help Offline

Without pressing F1 and then searching for help, you can directly type your keywords in the search bar provided on the VBE screen. This will return you all the relevant results related to VBA.

Search for Help in Excel VBA Screen

Search for Help in Excel VBA Screen

This is like an offline browser. You can navigate from topic to topic, you can go forward, backward like a browser, search etc.

About Excel Help Window

About Excel Help Window

Main Features of Microsoft Offline Help: (which I like personally 🙂 )

1. Offline availability

Offline availability is one of the most important feature. Also you do not need to carry a help file or save it by yourself somewhere in your local drive. It’s like wherever your workbook goes.. Help file follows 😉

2. Logical Grouping of Contents

All the contents are grouped logically by providing a Hierarchical Table of contents. This makes it very easy to read and get help quickly.

3. Search

A search bar is provided to search the content by providing a keyword. It gives you all relevant results.

Search - offline excel Help

Search – offline excel Help

4. Help with example

Wherever possible, helps are provided with some example. This means, it does not provide information about a function or formula, VBA method or any topic but also how to use it in your excel sheet. If it is a VBA function, method or property, it also provides you VBA code – how to use it.

VBA Code Example

VBA Code Example

5. Step by Step Instructions

You will find most of the help contents are having a step by step explaining approach.

6. Instructions step with screen shots

Wherever relevant most of the instruction steps will have a image of that screen, button etc.

Help Instructions - With Images

Help Instructions – With Images

And there are many more… it is up to you to figure out…

Offline Help in Excel 2013

Excel offline help is not available in Excel 2013 by default. This step is taken to keep the setup light. but you can always download it from here at this link:

Thanks for reading this article.

At the end some VBA code for you 😉


If Did_you_like_it = TRUE Then
   You can share it with your friends, colleagues, your own family or to your internet family.
   provide your feedback about, what you liked the most
Else
   Provide your comment for improvement.
End If

Buy a coffee for the author

Adsense

Download FREE Tools and Templates

There are many cool and useful excel tools and templates available to download for free. For most of the tools, you get the entire VBA code base too which you can look into it, play around it, and customize according to your need.

Dynamic Arrays and Spill Functions in Excel: A Beginner’s Guide
Dynamic Arrays and Spill Functions in Excel: A Beginner’s Guide

In today's tutorial, we'll be diving into the exciting world of dynamic arrays and spill functions in Office 365 Excel. These features have revolutionized the way we work with data, providing a more flexible and efficient way to handle arrays. I am going to explain...

How to Declare a Public Variable in VBA
How to Declare a Public Variable in VBA

While programming in VBA sometimes you need to declare a Public Variable that can store the value throughout the program. Use of Public Variable: Let's say you have 4 different Functions in your VBA Code or Module and you have a variable that may or may not be...

How to Copy content from Word using VBA

As many of us want to deal with Microsoft Word Document from Excel Macro/VBA. I am going to write few articles about Word from Excel Macro. This is the first article which opens a Word Document and read the whole content of that Word Document and put it in the Active...

What is Excel Formula?

Excel Formula is one of the best feature in Microsoft Excel, which makes Excel a very very rich application. There are so many useful built-in formulas available in Excel, which makes our work easier in Excel. For all the automated work, Excel Macro is not required. There are so many automated things can be done by using simple formulas in Excel. Formulas are simple text (With a Syntax) which is entered in to the Excel Worksheet Cells. So how computer will recognize whether it is a formula or simple text? Answer is simple.. every formula in Excel starts with Equal Sign (=).

You May Also Like…

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Join and get a FREE! e-Book

Don't miss any articles, tools, tips and tricks, I publish here

You have Successfully Subscribed!

Pin It on Pinterest