Forum Discussion
Where to find the objects under each of the Tools > References?
Hello
In Excel VBA, under Tools > References there are several references to add.
Is there a complete list of the objects/functions etc of all the references in one webpage/file so that I can see which reference I need to add to be able to access a particular object/function?
Thanks!
3 Replies
No, I'm afraid there is no such web page or document, since the list of possible references depends on what has been installed on a particular computer, so it can vary widely in number and functionality. Moreover, the number of objects, methods, properties and events in any given object library can be very large.
HansVogelaar thanks! But there should be some documentation right? Or at least say which object etc is available where? E.g. I need to make use of https://learn.microsoft.com/en-us/dotnet/api/system.windows.input.mouse.mousemoveevent?view=windowsdesktop-6.0 (system level mouse move event). Also, if a system level object is included in the Access reference, will it work only if in Access window or any system level window as soon as I include the Access reference in Excel?
Many libraries have their own documentation. See for example Office VBA Reference
The sidebar on the left has links to the documentation for Access, Excel, etc.
If you set a reference to (for example) the Microsoft Access 16.0 Object Library in Excel, you can use all objects, properties, methods and events of that library, but most of them will only make sense in an Access database.
