Have been on many of the MSDN and similar sites many times. Can't say it's 100% of the time, but don't they provide example code? They do at the link you posted. Wouldn't examples provide what you want? Then there is the Help documentation, which is mostly a repeat of the MSDN type pages. The only time I can recall not seeing examples is when you're in the site pages that only break out the object model, like this one
https://msdn.microsoft.com/en-us/vba...-vba-reference (object model link is in left nav pane).
Then again, I can't say there's never any examples inside of that documentation either. You have to watch out for documentation that is strictly VB or VB.Net when you're looking for VBA.
I know of no such key type of documentation. Methinks it would be an astronomical project to create. Maybe I don't fully grasp what you're need is since after years of dabbling in VBA, I don't have a problem understanding the words they use when laying out the parameters of a function, method or object. Perhaps you will too after a while.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.