B
bmurphy
This is about displaying HTML help files from a custom made Msgbox
because excel's Msgbox function evidently won't show the Contents/
Index/Search tabs in the HTML help window (Excel2003 windows XP).
I have downloaded http://www.excelguru.ca/ExcelFiles/HTMLHelp.zip
This indeed provides a very good re-enactment of excel's auto-sizing
Msgbox, but I made the following changes to get it to work a little
bit better.
I found that the Escape key won't cancel the custom message box. I
fixed this by putting in the following line:
.Cancel = True
right after each occurrence of
.Caption = "Cancel"
Also, to get the userform to work equally well with either a chm or
hlp type of file I changed the following line:
HTMLHelpShowContents 0, strHelpPath, &H1, 0
to:
If InStr(strHelpPath, ".chm") > 0 Then HTMLHelpShowContents
0,strHelpPath, &H1, 0
because otherwise an HLP file is first displayed momentarily at a
requested contextid, but then switches to the contents topic.
One other note - clicking on the X button in the upper right corner of
the userform closes the form, but triggers an Ok instead of a Cancel.
I haven't fixed that yet.
I did all this in Excel 2003. I haven't tried it yet in Excel 2007.
because excel's Msgbox function evidently won't show the Contents/
Index/Search tabs in the HTML help window (Excel2003 windows XP).
I have downloaded http://www.excelguru.ca/ExcelFiles/HTMLHelp.zip
This indeed provides a very good re-enactment of excel's auto-sizing
Msgbox, but I made the following changes to get it to work a little
bit better.
I found that the Escape key won't cancel the custom message box. I
fixed this by putting in the following line:
.Cancel = True
right after each occurrence of
.Caption = "Cancel"
Also, to get the userform to work equally well with either a chm or
hlp type of file I changed the following line:
HTMLHelpShowContents 0, strHelpPath, &H1, 0
to:
If InStr(strHelpPath, ".chm") > 0 Then HTMLHelpShowContents
0,strHelpPath, &H1, 0
because otherwise an HLP file is first displayed momentarily at a
requested contextid, but then switches to the contents topic.
One other note - clicking on the X button in the upper right corner of
the userform closes the form, but triggers an Ok instead of a Cancel.
I haven't fixed that yet.
I did all this in Excel 2003. I haven't tried it yet in Excel 2007.