{"id":4875,"date":"2016-12-11T09:02:21","date_gmt":"2016-12-11T09:02:21","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/wp\/?p=4875"},"modified":"2017-07-17T09:28:18","modified_gmt":"2017-07-17T09:28:18","slug":"microsoft-excel-offline-help","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2016\/12\/microsoft-excel-offline-help\/","title":{"rendered":"What if you do not have internet ??"},"content":{"rendered":"
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 \ud83d\ude09 i.e. Internet Not Working<\/i><\/strong>?? Or Have I got some excel macro which will fix your Internet Connection problem. Or an Excel Macro to boost your WiFi Signal??<\/p>\n Internet Connection Not Working<\/p><\/div>\n 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.<\/p>\n When you are on Active Worksheet and PRESS F1<\/strong> There will be a Help Window opened like below. This help windows will not have any documentation about VBA.<\/p>\n Microsoft Excel Offline Help<\/p><\/div>\n 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.<\/p>\n To get help about VBA, you first need to go to VBE window by pressing ALT+F11<\/strong>. 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.<\/p>\n VBA – Help Offline<\/p><\/div>\n 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.<\/p>\n Search for Help in Excel VBA Screen<\/p><\/div>\n This is like an offline browser. You can navigate from topic to topic, you can go forward, backward like a browser, search etc.<\/p>\n About Excel Help Window<\/p><\/div>\n 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 \ud83d\ude09<\/p>\n All the contents are grouped logically by providing a Hierarchical Table of contents. This makes it very easy to read and get help quickly.<\/p>\n A search bar is provided to search the content by providing a keyword. It gives you all relevant results.<\/p>\n Search – offline excel Help<\/p><\/div>\n 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.<\/p>\n<\/a>
How to Read Microsoft Excel product Offline Help<\/h1>\n
1. Excel Help for all the non-VBA stuff<\/h1>\n
<\/a>
2. Excel Help for VBA<\/h1>\n
<\/a>
<\/a>
<\/a>
Main Features of Microsoft Offline Help: (which I like personally \ud83d\ude42 )<\/h1>\n
1. Offline availability<\/h2>\n
2. Logical Grouping of Contents<\/h2>\n
3. Search<\/h2>\n
<\/a>
4. Help with example<\/h2>\n