Microsoft Visual Basic Help or pressing F1 while inside the Visual Basic Editor. The very best part about any of it is the search feature. I take advantage of this all the right time! Another built-in feature that can help you solve your problems is the thing browser and is a great tool to use when you’re stuck and don’t know very well what to do next.
Object Browser (or just strike F2) and use the search club. You should screen the Developer tab or run in developer mode when you wish to create macros, run macros that you documented previously, or create applications to use with Microsoft Office programs. To show the developer tabs: Click on the Microsoft Office Button and then click Excel Options, PowerPoint Options, or Word Options. Click Popular, and then select the Show Developer tabs in the Ribbon check box. When you’re programming an elaborate macro, it’s often a good idea to visualize how it’s going to work before you begin typing away.
For these large problems I like to create flowcharts to get a standard idea of how the code will stream. In addition, it helps to think about the steps the macro should perform, including all the user inputs. I write out a flowchart often, decision tree, or sketch an activity map quickly.
No, I haven’t memorized each and every function that can be used in VB. Instead, I favor to learn where that information is and simply look it up really fast. …