geriso.blogg.se

When you select a window from the menu, it displays in the location where you last placed it.

For example, you can only view the Toolbox from a UserForm window. The View menu lists the available Visual Basic Editor windows. You can select which windows display and the locations where they display. You can only access some windows, such as the Toolbar and UserForm windows, from specific locations, such as when you create a userform. You may also find the Immediate window useful for quickly testing a statement before adding it to your code. The most commonly used windows are the Project Explorer, the Properties window, and the Code window.

Although Microsoft provides a basic window setup, like most development environments, you can customize this setup by rearranging, resizing, removing, and adding windows. This training is available for groups of 4 or more students.The Visual Basic Editor contains several different windows that you use when developing macros. Jackie has provided software training for employees of The Coca-Cola Company, Emory University, Novelis, and more. Our courses can be customized to your needs. Need onsite group training? Call 770.498.7333 or email us. Her company also offers Excel 2007, 20: Certification Prep, Basic through Advanced training. She learned to program with Visual Basic over 20 years ago, and has developed the following Advanced-level Excel courses: Jump Start Excel Macros/VBA™, Painless Pivot Tables ™ and Excel’s Best Functions – from A to Z™. Jackie Kiadii is an Information Technology professional with a degree in Computer Information Systems. To make it easier for students to see my screen, I usually use Verdana 14 pt. A shortcut for accessing the VBE is ALT F11.Ĭhange the font and size. You can get to it by clicking the Developer tab, then Visual Basic in the Code group. Fortunately, changing the font is really quick and easy. The default font of Courier 10 is not the easiest on the eyes. When I teach Excel Macros and Visual Basic for Applications (VBA) courses, one of the student complaints is how difficult the Visual Basic Editor (VBE) is to read.