MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

how to make a help file for a project?

  Asked By: Harley    Date: Jan 11    Category: MS Office    Views: 895

I am looking to make a help file for a VBA project in Excel. Is there
some (free) tool avialable to make such a help file?



1 Answer Found

Answer #1    Answered By: Kenny Moore     Answered On: Jan 11

Do you mean a "classic" Windows help  file? Microsoft is encouraging developers
to switch to HTML-based help instead. I used to use Visual Help Pro to create
Help files. RoboHelp is probably the cream of the help compiler crop. I don't
know of any freeware.

Let me give you two alternatives for providing help in excel  applications.
John Walkenbach has a nice flexible userform for displaying help text. You can
read about it and even download a free  working copy at his website:


I usually just put my help text on another sheet in the workbook. I have a
command button on the userform (or worksheet) that moves to the help sheet and
displays it full screen:

'Userform frmMain has a command button cmdHelp
Private Sub cmdHelp_Click()
Me.Hide 'or Unload Me
ActiveWorkbook.Sheets("Help 1").Activate
ActiveWindow.Zoom = 100
Application.DisplayFullScreen = True
Cells(1, 1).Select
End Sub

On the help sheet, I have a "Close Help" button at the top next to a heading.
Freezing panes beneath the heading keeps the button always in view. By turning
gridlines off and displaying full screen, I have a big, blank space in which to
put my help. The help
can include formatted text, WordArt, graphics, screen captures, audio clips,
etc. It's a lot easier to maintain than a separate Help file.

'Close Help command button on sheet "Help 1" sends user
'back to correct sheet and re-displays frmMain.
Private Sub cmdHelp1_Click()
On Error Resume Next
Application.DisplayFullScreen = False
End Sub

Didn't find what you were looking for? Find more on how to make a help file for a project? Or get search suggestion and latest updates.