Macros (that is, sets of VBA commands) are stored in code units. In any Excel workbook, we can create any number of program modules and place our macros there. One module can contain any number of macros. All modules are accessed using the Project Explorer window in the upper left corner of the editor (if not visible, press CTRL + R). There are several types of software modules for different situations:
Unfortunately, the VBA editor interface and help files are not translated into Russian by Microsoft, so you will have to put up with English commands in menus and windows:
New versions (Excel 2007 and later) to do this, first display the tab Developer (Developer,) . Choose File – Preferences – Customize the Ribbon (File – Options – Customize Ribbon) and turn on the right side of the window box developer (Developer,) . Now, on the tab that appears to us to be the main tools available to work with macros, including those necessary to us button (Visual Basic Editor). In older versions (Excel 2003 and older), go to Tools – Macro – Visual Basic Editor (Toos – Macro – Visual Basic Editor) . To enter commands and form a program, i.e. To create a macro, you need to open a special window – the editor of VBA programs built into Microsoft Excel. Creating macros in the Visual Basic editor
0 kommentar(er)
