ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   inputbox and helpfile (https://www.excelbanter.com/excel-programming/358550-inputbox-helpfile.html)

[email protected]

inputbox and helpfile
 
Can someone explain what I am doing incorrectly with this code?

examle 1 and 2 work OK. example 3 does not display a help button on
the inputbox. I believe the syntax is ok, so what am I doing wrong?

tia
g.

example 1
MsgBox "Press the help button", _
Buttons:=vbOKCancel Or vbMsgBoxHelpButton, _
HelpFile:=ThisWorkbook.Path & "\my.chm", _
Context:=144

example 2
strData = InputBox( _
Prompt:="Enter a number" & vbLf & vbLf & _
"Enter a 0 to quit", Title:="Add Rows", _
HelpFile:=ThisWorkbook.Path & "\my.chm", Context:="144")

example 3
'lNumber = Application.InputBox( _
Prompt:="Enter a number", Title:="Number", _
HelpFile:=ThisWorkbook.Path & "\my.chm", HelpContextID:=144, _
Type:=1)


All times are GMT +1. The time now is 05:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com