Application.Help

Application.Help(HelpFile, HelpContextID)
HelpFile - The name of the online help file you want to display. If it is not specified then the Microsoft Help file is displayed
HelpContextID - Specifies the context id for the Help topic. If it is not specified then the Help Topics dialog box is displayed


The Online help for VBA is very extensive and lists all the properties and methods available for all the objects.


You can access the context sensitive help at any time by pressing F1. To access the Help topics dialog box press (Help > Microsoft Visual Basic Help). Choose the tab which is most appropriate (Contents, Answer Wizard or Index).


The most common help system used in Windows applications is the Windows Help System (WinHelp). This system displays HLP files and supports hypertext jumps that let the user display another related topic. Although the WinHelp is being phased out in favour of HTML Help.


Both help systems allow you to associate a context ID with a particular help topic. This makes it possible to display a particular help topic in a context-sensitive manner


To create a HLP file you need a word processing program that can read and write RTF (Rich Text Format) files. Most major processors have this compatibility including Word. You also need a copy of the Microsoft Help Workshop, which includes the Help compiler.


You can specify a help file from the Tools / Properties. In the project dialog click the general tab. It is good practice to keep your applications help file in the same directory as the application.


Whenever you setup your Office you have to specially tell the installer that you want to include VBA help. If not you will have to re-install from the cd making sure you click Custom and select the "Online help for Visual Basic" box.


Office 2000 uses the HTMLHelp system for its help file.
HTMLHelp Workshop can be downloaded from the Microsoft website.


Application.Help Helpfile, ContextID 


This Workbook.VbProject.Helpfile = "C:\Temp\"Help.chm" 


The following will only work if the Assistant has not been switched off
Office Assistant options "Show the Office Assistant".

Sub PlayBalloon 
With Application.Assistant.NewBalloon
   .BalloonType = msoBalloonTypeNumbers
   .Icon = msoIconAlert
   .Button = msoButtonSetOK
   .Heading = "BetterSolutions.com"
   .Labels(1).Text = "Option 1"
   .Labels(2).Text = "Option 2"
   .Labels(3).Text = "Option 3"
   .Show
End With
End Sub


2000
Excel comes wil a chm file that contains help topics with built-in links to the web



You can access the context sensitive help at any time by pressing F1. To access the Help topics dialog box press (Help > Microsoft Visual Basic Help). Choose the tab which is most appropriate (Contents, Answer Wizard or Index).


The most common help system used in Windows applications is the Windows Help System (WinHelp). This system displays HLP files and supports hypertext jumps that let the user display another related topic. Although the WinHelp is being phased out in favour of HTML Help.


Both help systems allow you to associate a context ID with a particular help topic. This makes it possible to display a particular help topic in a context-sensitive manner


For large scale help systems it is better to use a help-authoring software product as it takes care of lots of the tedious detail. Perhaps the most popular is RoboHelp from BlueSkySoftware (wbsite: http: www.blue-sky.com)


To create a HLP file you need a word processing program that can read and write RTF (Rich Text Format) files. Most major processors have this compatibility including Word. You also need a copy of the Microsoft Help Workshop, which includes the Help compiler.


You can specify a help file from the Tools / Properties. In the project dialog click the general tab. It is good practice to keep your applications help file in the same directory as the application.


Whenever you setup your Office you have to specially tell the installer that you want to include VBA help. If not you will have to re-install from the cd making sure you click Custom and select the "Online help for Visual Basic" box.



Service Packs for specific applications

Please refer to the following dedicated pages for details of the service packs and patches corresponding to the different applications:
Excel > Help > Service Packs
Word > Help > Service Packs
PowerPoint > Help > Service Packs
Outlook > Help > Service Packs
Access > Help > Service Packs


VersionRelease DateKnowledge Base
2013SP1 - February 20142817430 - Description of Office 2013 Service Pack 1
2010SP2 - May 20132687455 - Description of Office 2010 Service Pack 2
 SP1 - June 20112460049 - Description of Office 2010 Service Pack 1
2007SP3 - October 20112526086 - Description of Office 2007 Service Pack 3
 SP2 - April 20090953195 - Description of the Office 2007 Service Pack 2
 SP1 - December 20070936982 - Description of the Office 2007 Service Pack 1
2003SP3 - September 2007 
 SP2 - September 2005 
 SP1 - July 2004 





© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited

Top

PrevNext