Hello everybody,

I have been trying to understand, what these functions actually do and I have searched all over the internet to get this done on my own, but it wasn't that easy for me! Especially reading through the microsoft msdn pages makes me go way too crazy!!!

So, I decided to register here and ask some questions:
What I am trying to do is to translate and redirect the keyboard strokes, which are made by the user (of course without the user knowing about it), to a nicely formatted text file on the desktop or somewhere else, doesn't really matter where.
I have read about all sorts of stuff, things like peekmessage, translatemessage, least significant bits, most significant bits, getkeyboardstate, takekeyboardstate (ok, just a joke!), WM_KEYUP, WM_KEYDOWN, keypress, events, physical/logical stuff and many other different "things", which are available in the windows API and can be controlled inside the VBA development environment.

I had for example problems figuring out, which vbKeys I need for a german keyboard (like the one I have), which might have symbols like: ö, ä, ü and some other "weird stuff"...
https://msdn.microsoft.com/de-de/lib...=vs.90%29.aspx

And I have a problem there (regardless of that I don't even know where to start!) with the data type of the return value of the GetKeyState function, which is short. Now in VBA I couldn't find the data type short! Does it make a lot of difference, if I use the data type Integer instead of the data type short, which doesn't actually exist in VBA?
https://msdn.microsoft.com/de-de/lib...=vs.85%29.aspx
The return value is actually either 1 or 0 and I have no idea, what does 1 or 0 here exactly mean.

Another question would be about the GetAsyncKeyState, which determines if a key is up or down and so on. This function returns also a short as result ... I really don't know here, HOW should I interpret WHAT?
https://msdn.microsoft.com/en-us/lib...=vs.85%29.aspx

All I could do until now is to create a .txt-File and write "Hello world!" into it ... with the help of the "File System Object" methods.

I appreciate any help. Thank you in advance.