Using the VBA Excel Example File

Note - Security Updates

In a connected world security updates are now a fact of life. Get used to them.
Microsoft have done a mighty job of securing Windows starting with XP SP2 released
in Aug 2004. Since then a string of updates have reduced the humble CHM to the
status of a humble local help system. It's a shame but we need to move on.

The .zip file includes a "CHM-example.chm" file. When coming over
the net and unzipped to a local drive not all of the content is shown in the
help viewer.

to open the CHM file right-click the saved file, click Properties, and then
click Unblock.

Now continue ..

Context-sensitive Help for a button

Double-click "CHM_VBA_example.xls" and allow Macro's - dependent
on your security properties. You can see two buttons calling the help window
for following Context-ID:

Context sensitive help topic 10010

Context sensitive help topic 20010

Start the Visual Basic Editor and see how the code works.

Context-sensitive Help for a function

A file runs automatically when starting Excel with the file above or go to
Tools | Macros (or press Alt+F8) and run "AddUDFToCategory"

In the "Insert Function" dialog box you see a category "Date
& Time" - select it.

So, as you can see there are two functions "DayName" and "TestMacro"
on the dialog box. Click "Help on the function" to call the help window
and show the topic mapped to the function e.g. context-ID=20000.