Create a help file into VBA

[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

 

[Bob Phillips]

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)

 

[Alex St-Pierre]

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

 

[Bob Phillips]

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)