Excel VBA Function Method API Windows Function User32.dll Alias Declare Library List .. thingies :)
Hello,
I am sorry if the Thread title does not quite match what it is that I want. As usual I am not quite sure myself what it is that I am talking about…. :)
Maybe an example will help get across which List I am trying to get hold of.
In Excel VBA there is a message box pop up thingy MsgBox, the VBA Message Box Function ( https://msdn.microsoft.com/en-us/vba/la ... x-function" onclick="window.open(this.href);return false; )
This apparently uses a “Windows API software code thingy”, ( "MessageBoxA" )
Yesterday I found out that is quite easy to “use that standard code more directly”. All you need is a simple single code line like
Code: Select all
Public Declare Function APIssinUserDLL_MsgBox Lib "user32" Alias "MessageBoxA" (Optional ByVal hWnd As Long, Optional ByVal Prompt As String, Optional ByVal Title As String, Optional ByVal buttons As Long) As Long '
' MessageBoxA http://www.tek-tips.com/faqs.cfm?fid=4699
So I want a good list of those Pubic Declare thingys code lines
So Ideally what I would like is a list of Excel Methods and Functions and alongside those Methods and Functions the “ Excel VBA Function Method API Windows Function User32.dll Alias Declare Library “ thingy code line.
If, in addition, I can get an explanation of all the parameter arguments as well then so much the better.
Currently, for example, I am trying to find the “ Excel VBA Function Method API Windows Function User32.dll Alias Declare Library “ stuff for the VBA Application Input Box Method ( https://msdn.microsoft.com/en-us/vba/ex ... thod-excel" onclick="window.open(this.href);return false; ), ( and possibly the VBA Input Box Function ( https://msdn.microsoft.com/en-us/vba/la ... x-function" onclick="window.open(this.href);return false; )
Possibly, they use the same “ Excel VBA Function Method API Windows Function User32.dll Alias Declare Library “ thingy. I don’t know
I have also asked this question in this Excel Forum here https://www.excelforum.com/excel-progra ... ost4822879" onclick="window.open(this.href);return false; , as I am mainly interested in using those API Windows Function User32.dll Declare Library Alias thingys as they apply to Excel VBA Methods and Functions. I was not sure if there might be a separate shorter list specifically for Excel VBA that someone there might know about. I will feedback any info that I get from there.
Thanks
Alan
P.s. If anyone knows what it is that I am talking about, could they possibly explain it to me in simple terms what that is.
My guess is that I am talking about …….a “Declaring” code line that gives my code access to a set of standard programs shipped with Windows that are available for use in various things, such as Excel, Word, Access etc…