Source for VBA syntax

Is there a document or location where can one get all the syntax for VBA expressions? That is, a source document where one can drill down for all the properties, methods, enumerations etc for every object. For example, I am trying use VBA to place and format the properties of a pie chart in a worksheet, and by using online search engines I have found several excellent bits of advice from those who understand VBA better than I do. I have found the line “ActiveChart.SeriesCollection(1).Points(1).Format.Fill.Forecolor.rgb=”
which will get me well on the way to sorting out the segment colours, but where is the documentation for it? And where do I find the other things that SeriesCollection will let me do? I have used the F1 help function in VBA, which is rarely of any use. I have used the Object Browser in the Excel VBA window, which does not go deep enough. Intellisense, when it is available is helpful, but in this and many other cases it does not work. When the procedure is up and running, one can get some information from the Locals window, but that is no use while one is writing the procedure. I have a couple of very thick books on Excel programming, but they do not cover all situations. Recording a macro is a great way of finding the syntax, but again in this and many other cases, it does not actually record anything after the first action. I shall doubtless find online the correct format for this partiular problem, but where should I look for the definitive answer to all such questions?