View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Create a help file into VBA

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)

"Alex St-Pierre" wrote in message
...
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
--
Alex St-Pierre


"Bob Phillips" wrote:

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" wrote in
message
...
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
--
Alex St-Pierre