Please teach Excel macro masters, the simple use of excel macro functions

Summary:1. After turning on the computer, create a new excel, click the office icon in the upper left corner of the main interface, and click options. The specific steps are shown in the following figure:

2. In the new interface, check the development tools option and click OK. 3. Click the Development Tools option in the menu bar, and then click Record Macro. 4. Fill in the name and shortcut key, set the save location, and click OK.

5. Change the color of excel** to red. 6. After the Excel macro is recorded, you can click to stop recording. 7. Click the mouse to other positions, and then press the shortcut key to modify the color.

Demo Environment Information:Computer model: thinkpad wing 14 slim, system version: window10 home Chinese version, software version: excel2020.

1. After turning on the computer, create a new excel, click the office icon in the upper left corner of the main interface, and click options. The specific steps are shown in the following figure:

2. In the new interface, check the development tools option and click OK. The specific steps are shown in the following figure:

3. Click the Development Tools option in the menu bar, and then click Record Macro. The specific steps are shown in the following figure:

4. Fill in the name and shortcut key, set the save location, and click OK. The specific steps are shown in the following figure:

5. Change the color of excel** to red. The specific steps are shown in the following figure:

6. After the Excel macro is recorded, you can click to stop recording. The specific steps are shown in the following figure:

7. Click the mouse to other positions, and then press the shortcut key to modify the color. The specific steps are shown in the following figure:

Note: The above operation steps need to be operated in order, and do not shuffle the order.

The Excel macro introductory tutorial is as follows:Operating Equipment: Dell laptops.

Operating system: win10

Operating procedure: excel2017

1. First open Excel, click Development Tools, click to select "Insert", and then select the "Button" icon in the control in the form of the drop-down menu.

2. Then, when the Assign Macro dialog box pops up, a new button will be created on the standalone computer.

3. This will enter the interface of the VBA program macro of Excel, write a demo macro after entering, and click "Save".

4. At this time, the program has been written, and when you click the button in excel, a hello world message prompt box will pop up.

In excel, in order to improve work efficiency and have to carry out **, this time it involves macro programming, the following is the content I brought about excel 2010 macro programming tutorial, welcome to read!

Excel 2010 Macro Programming TutorialExcel 2010 Macro Programming Tutorial 1:First, I've built a demo example. The function to be implemented in this article through macros is to place column a","The text before the number is extracted.

Excel 2010 Macro Programming Tutorial Figure 1Excel 2010 Macro Programming Tutorial 2:Right-click in sheet1 and select View.

Excel 2010 Macro Programming Tutorial Figure 2Excel 2010 Macro Programming Tutorial 3:The VBA page is displayed.

Excel 2010 Macro Programming Tutorial Figure 3Excel 2010 Macro Programming Tutorial 4:

end sub

Excel 2010 Macro Programming Tutorial Figure 4Excel 2010 Macro Programming Tutorial 5:Click Save when the input is complete, and click Yes in the pop-up dialog box.

Excel 2010 Macro Programming Tutorial Figure 5Excel 2010 Macro Programming Tutorial 6:Then a dialog box pops up, click OK to go down. In fact, these two steps can be set up to avoid popping up prompts, which I will share with you in the future experience.

Excel 2010 Macro Programming Tutorial Figure 6Excel 2010 Macro Programming Tutorial 7:Then click on View-Macro.

Excel 2010 Macro Programming Tutorial Figure 7Excel 2010 Macro Programming Tutorial 8:Select View macros.

Excel 2010 Macro Programming Tutorial Figure 8Excel 2010 Macro Programming Tutorial 9:Select the macro you want to execute from the list of macros, and then click Execute.

Excel 2010 Macro Programming Tutorial Figure 9