View Single Post
 
Old 02-12-2024, 06:28 AM
Italophile Italophile is online now Windows 11 Office 2021
Expert
 
Join Date: Mar 2022
Posts: 542
Italophile is just really niceItalophile is just really niceItalophile is just really niceItalophile is just really nice
Default

You're welcome.

Recording a macro can be a useful step in discovering the syntax for an action, but the code produced, if any, will be of inferior quality.

The VBA editor has some tools that can help you learn and which are only a keypress away.
  • F1, when the cursor is in a keyword, brings up the online documentation.
  • F2 displays the Object Browser which can help you to discover the objects, their methods, properties, and events, that you can work with. You can either browse the object tree or use the find button to discover potentially useful properties or methods. In the 30+ years that I have been writing VBA this has always been the most helpful tool for me.
Reply With Quote