Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Best Way to Create Help Screens for Excel Forms
I'd like to create help screens for various userforms I have on an Excel
application. I'd like to display the help screens with the press of a button on each userform. But, I'm wondering what's the best method for creating help screens. I've considered the following 3 alternatives. 1. Create help screens that are userforms themselves. That would give me the freedom to embed .bmp images. But, the text-editing would be cumbersome in a textbox control. 2. I thought about having a text-only help screens that I can have executed from using the Shell command. But, the problem is that the location of NOTEPAD.EXE can vary from computer to computer. 3. I thought about putting all the help on a webpage. But, that could take up a lot space on the web server, especially I want include graphics. Plus, I don't how many people would want to refer back to a webpage for help. Does anybody have any other good suggestions? Thanks in advance. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Best Way to Create Help Screens for Excel Forms
Bob,
Have a look at this page in John Walkenbach's site http://j-walk.com/ss/excel/tips/tip51.htm Neil "Bob Kaku" wrote in message ... I'd like to create help screens for various userforms I have on an Excel application. I'd like to display the help screens with the press of a button on each userform. But, I'm wondering what's the best method for creating help screens. I've considered the following 3 alternatives. 1. Create help screens that are userforms themselves. That would give me the freedom to embed .bmp images. But, the text-editing would be cumbersome in a textbox control. 2. I thought about having a text-only help screens that I can have executed from using the Shell command. But, the problem is that the location of NOTEPAD.EXE can vary from computer to computer. 3. I thought about putting all the help on a webpage. But, that could take up a lot space on the web server, especially I want include graphics. Plus, I don't how many people would want to refer back to a webpage for help. Does anybody have any other good suggestions? Thanks in advance. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Best Way to Create Help Screens for Excel Forms
"Bob Kaku" wrote in message ... I'd like to create help screens for various userforms I have on an Excel application. I'd like to display the help screens with the press of a button on each userform. But, I'm wondering what's the best method for creating help screens. I've considered the following 3 alternatives. 1. Create help screens that are userforms themselves. That would give me the freedom to embed .bmp images. But, the text-editing would be cumbersome in a textbox control. 2. I thought about having a text-only help screens that I can have executed from using the Shell command. But, the problem is that the location of NOTEPAD.EXE can vary from computer to computer. 3. I thought about putting all the help on a webpage. But, that could take up a lot space on the web server, especially I want include graphics. Plus, I don't how many people would want to refer back to a webpage for help. Does anybody have any other good suggestions? Thanks in advance. You can use a commercial help programme like robohelp and compile a .hlp file who's entries can be accessed from VBA Keith |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Best Way to Create Help Screens for Excel Forms
Bob,
I'd like to create help screens for various userforms I have on an Excel application. I'd like to display the help screens with the press of a button on each userform. I would recommend delivering the help in a WinHelp (.hlp) or HTML Help (.chm) file, as these are the standard formats for online help in Windows. This page provides extensive information on how to connect WinHelp and HTML Help files to Excel applications: http://www.microsoft.com/technet/pro...part2/ch13.asp And for guidelines on how to start building your help file, see: http://helpware.net/htmlhelp/basics.htm -- Pete (Microsoft Help MVP) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i create forms using microsoft excel? | Excel Discussion (Misc queries) | |||
How 2 create an Excel Form using & linking items on Forms Toolbar | Excel Discussion (Misc queries) | |||
I would like to create forms on my website with excel? | Excel Discussion (Misc queries) | |||
create excel spreadsheet to display data from filled text forms | Excel Discussion (Misc queries) | |||
Can I create custom forms to add data to a Excel Spreadsheet? How. | Excel Discussion (Misc queries) |