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

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" <(E-Mail Removed)> wrote in message
news:F4588FD6-6A72-47C5-BCF8-(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> wrote in message
> news:F4588FD6-6A72-47C5-BCF8-(E-Mail Removed)...
> > 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
>
>
>

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" <(E-Mail Removed)> wrote in message
news8478711-A887-4CD3-A9D7-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in
>> message
>> news:F4588FD6-6A72-47C5-BCF8-(E-Mail Removed)...
>> > 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
>>
>>
>>