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
|