I've searched and tried some code from various places and I can't get a .chm (help) file to load on my user form.
whatsthisbutton and whatsthishelp are both set to True in properties window for the userform.
forecasthelp.chm is the help file name
Code I'm using:
Private Sub UserForm_Click()
' Turn mouse pointer to What's This question mark.
WhatsThisMode
the .chm file is in the same folder as the Excel workbook.
Application.Help ThisWorkbook.Path & "\" & forecasthelp.chm, 110
'110 is the HelpContextID associated with the file
End Sub
Like most VBA, it seems like this should be simple thing but isn't. Any suggestions?
I'm on Excel 2007.
Thanks,
Bob
whatsthisbutton and whatsthishelp are both set to True in properties window for the userform.
forecasthelp.chm is the help file name
Code I'm using:
Private Sub UserForm_Click()
' Turn mouse pointer to What's This question mark.
WhatsThisMode
the .chm file is in the same folder as the Excel workbook.
Application.Help ThisWorkbook.Path & "\" & forecasthelp.chm, 110
'110 is the HelpContextID associated with the file
End Sub
Like most VBA, it seems like this should be simple thing but isn't. Any suggestions?
I'm on Excel 2007.
Thanks,
Bob