There’s an interesting discussion at Smurf about the macro recorder. I rarely use it, but I used to use it quite often. I actually just used it last week for something to do with FormatConditions, but I don’t remember the details. Intellisense or the Object Browser usually gets me where I want to go.
The number one reason people say they use the recorder is get object names and syntax. It’s great for that, no doubt. But is that the best delivery mechanism for syntax? I would think good documentation would be more useful and efficient than the macro recorder.
There is one aspect to the macro recorder that you’ll never get from the best documentation: A direct mapping from the UI to code. If you don’t know about the FormatConditions object, then you may not have any luck determining how to manipulate conditional formatting in code. If you know how to do it in the UI, however, the recorder will at least give you a clue.
If VBA had perfect documentation (complete, good/relevant examples, context) would that change how much you use the macro recorder?