Create a help file into VBA

  • Thread starter Thread starter Alex St-Pierre
  • Start date Start date
A

Alex St-Pierre

Hi !
I would like to create a help file like .chm or .hlp file but inside VBA
code. All the program informations is include into an excel workbook. So, to
simplify the distribution, I would like to integrated a help popup box into
the VBA code. Does anyone have already done something like that?

If I create the help file into a form, is it possible to have a form
independant of Excel. So, the user will be able to select help file text and
select Excel cell's. (to be able to make a copy-paste from help file to
excel).
If not, is there a possibility to create a help file somewhere and open it
thereafter.

Thank you!
Alex
 
At one point you seem to want it integrated into Excel, then you don't.

IMO, if the help is of any complexity, you need a good Help Authoring tool,
like Help and Manual, or West Wind. If it is simple, a simple multi-page
form should do the trick.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
So, I could do a multipage. At the left of the form, it should have nodes and
at the right, the page will be displayed regarding of which node it has been
selected. I will display sample text and I would like to allow user to copy
and paste the text into Excel. Is there a way to do that or if it will
require to close the form to be able to paste the text?
Thank you!
Alex
 
The tabs (what you call nodes) are at the top of the multi-page. Your
application code can determine which page to display (they start at base 0).

If you show the form modally, it is possible to paste onto the worksheet

Userform1.Show 0

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top