宏详解（Macro explanation）.docVIP

宏详解（Macro explanation） New term: macro means a series of VBA statements that EXCEL can execute. The macro to be recorded below is very simple, just changing the cell color. Please complete the following steps: 1) open a new workbook to make sure other workbooks are closed. 2) select the A1 cell. Call the frequently used toolbar. 3) select the tool macro - record the new macro. 4) enter change color, replace the default macro name as a macro name, click OK, note that at this time the status bar shows recording, especially the stop recording toolbar is also displayed. Replacing the default macro name is primarily convenient for separating these macros. This macro name can be up to 255 characters, and must start with a letter. The characters available include letters, numbers, and underscores. Whitespace is not allowed in macro names. Usually underlined space is used. 5) select the format of the cell, select the red in the pattern option, and click ok. 6) click the stop recording toolbar button to end the macro recording process. If the stop recording toolbar start does not appear, select tools and macro and stop recording. You can execute it after recording a macro. 1.4 execute macro When executing a macro, the EXCEL executes as macro statements, just as the VBA code does remote control of the EXCEL. But VBAs remote control not only makes the operation easy, but also allows you to get some functionality that can not be achieved using the EXCEL standard command. And, once youre familiar with EXCELs remote control, youll wonder how you managed to get through without these remote controls. To perform the macro you just recorded, you can follow these steps: 1) select any cell, such as A3. 2) select the tool macro - macro to display the macro dialog box. 3) select change color, and select execute, then the color of the A3 cell becomes red. Try selecting other cells and areas of several cells, and then execute the macro to impress. 1.5 view the recorded code What exactly is