ब्लॉग कोशिश कर रहा है بلاگز کی ک*Trying Blogs

[DocAElstein]

This is a solution ( from me ) to this excelforum Thread :
https://www.excelforum.com/excel-new...contextid.html

It is also required in support of this excelfox Thread :
http://www.excelfox.com/forum/showth...utBox-Function

Original Question

VBA Application.InputBox Option HelpFile:= HelpContextID:=

Hi,
. I am trying to learn and practice with the .InputBox just now.
. I am getting there with most aspects. But I am struggling to find good explanations of, or rather, examples of actually using the two optional arguments Helpfile and HelpContextID
. Can anyone give me or point me in the direction of a working example / examples using specifically these options, with a brief explanation of what is going on

Thanks
Alan

_
A Bump on the question:

Bump
( on getting these optional things, HelpFile:= _ , HelpContextID:= , to do what ever it is they are supposed to )


Hi
I am getting clued up on the simpler “Pop up User Info getting / giving Window” stuff currently.
I would like to consider them all at their full potential for a better comparison.

So I could do with having an answer to the question that is the main subject of this Thread.
It is a couple of years along the way now – I had just started with computers back then.
I think I may have a better chance now of understanding the Link given to me in post #2 https://www.excelguru.ca/content.php...r-Applications
It is clearly not straight forward so I had no chance back then of having the slightest idea what that was all about. At first glance I think I might at least be able to make a start now…

I can’t find any other articles or documentation on this, -
If anyone has any input on this, for example a full working example that they are able to walk me through using, then it could probably save me a lot of time.

Otherwise I will see you here again, in a couple of weeks probably, … when I have sussed it out myself..

Thanks
Alan

P.s.
By the way…. I think I will try initially to look at the HelpFile:= _ , HelpContextID:= _ in conjunction with the InputBox Function ( https://msdn.microsoft.com/en-us/vba...utbox-function ) in preference to the Excel Application.InputBox Method ( https://msdn.microsoft.com/en-us/vba...x-method-excel ) because
_a) I am aware now that the Excel Application.InputBox Method has bugs
( The only difference in the working is that the Excel Application.InputBox Method has an extra last optional argument, Type:= . (One “advantage” of this being that for giving Type:=8 will return an object, which will be the range object of the cells either typed in (as an address), or alternatively selected)……I expect this extra complication is what probably screws things up.. )
_b) I believe the InputBox Function is possibly more fundamental, and I am hoping possibly to further my investigations into a ““more direct API route” with this ( https://www.excelforum.com/excel-pro...rary-list.html ) , although it is not clear currently if there is a “more direct API route” for this yet. )
I have also learned and partially myself perfected using string references for referring to range objects as an alternative, and this trend I will be perusing and I expect it to become possibly more trendy to do that. ( It certainly makes code a lot ‘prettier )







Ref
https://stackoverflow.com/questions/...38078#48338078
http://www.mrexcel.com/forum/excel-q...ox-method.html
http://www.vbforums.com/showthread.p...3-but-not-2007

_.______________________________________---

Last answer before final solution

You obviously did not drink the Microsoft 'Kool Aid', because its' not a bug, its a feature.

Reply _........

Lol.. I really should have thought of that “Feature” idea. I keep trying tell people about the special Forum Software “Features” that excelforum has.
I guess you only get this free drug https://imgur.com/gallery/GjZgOM1 if you are a professional programmer looking to buy some software. I don’t know why but it reminds me of Cresta ( Its Frothy Man https://www.youtube.com/watch?v=tvo2Hddqg3I ), although as I recall the Cresta that I was hooked on as a Kid was pink in color ). Maybe that has some similar secret hidden ingredient to make you like the providers stuff…

I will have to battle through and get the things to the stand that I conceive without a drugged up mind ( well not on Microsoft’s drug anyway ) as “working”. …. Well, … after a fashion …. I think maybe I have in this case … at least working enough to make the rational decision not to use it…
_._____________________

_..........with Final answer in next two posts:

[DocAElstein]

Create a Help Project. Aka make a .chm file that probably won't work

Part 2 A walkthrough example
Part 2a) Getting a .chm file that might come up by double clicking on it or via Application.Help HelpFile:=MyCodeX.chm

_3_ Buggery Features 3 / Workaround ( To understanding WTF Microsoft HTML Help Workshop is ) :
This is just one way that on average lead to the most success of getting a final working .chm
Instead of starting from scratch, I found I had a better chance of producing a final .chm if I started with one that worked and went backwards.
Unfortunately this is characteristic of many things Microsoft. You need to have a working answer to or a working solution to get there ? A "chicken and egg" situation. So I have done my best to give a working solution on which to build / modify.

In a way I am not really using the Microsoft HTML Help Workshop as it is intended. I guess the Idea is that you can make , edit and organise all the files you need to create a final .chm with the Microsoft HTML Help Workshop Development Environment. Sounds simple but I could not find any decent documentation or learning material. In most of the You tube videos the author seemed confused and surprised half the time as to what was actually going on


To start with you need to have a working .chm.