Probably one of the most useful tools in the VB Editor in Office applications, the Object Browser can be accessed by pressing f2 (Ctrl+Cmd+B in Mac Excel) or using View – Object Browser from the menu.
This tool provides a searchable listing of all the available objects, methods, properties, events, enums etc. for the object libraries you have loaded in the current project. It is a great way of finding out what is available as well as the syntax required to use a given object/method/property/event.
Learn to use it – you won’t regret it!