Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a help file into VBA
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a help file into VBA
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a help file into VBA
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to create dbase file from text file? | Excel Discussion (Misc queries) | |||
Possible to create XL file then run XL VBA (to format & filter XL file) from Access VBA? | Excel Discussion (Misc queries) | |||
Create CSV file based on table in Excel file | Excel Programming | |||
Create a single xls file with each import csv file having its own tab | Excel Discussion (Misc queries) | |||
Create a batch file from a number of Excel File | Excel Programming |