What is Excel Macro? Tutorial on using Excel macros

Excel What is a macro ？Excel What is the macro tutorial like ？ All my friends are using excel form , Want to get started using macro tutorials to make work more efficient . Do the little friends know what macro is ？ In fact, macros are programs that store a series of commands . Do you know about the macro tutorial ？ Don't worry ,Excel A tutorial on the use of macros. Here comes ！ Follow Xiaobian to have a look ！
Excel What is a macro ？
EXCEL A macro of a table is based on VB A macro language of VBA Script , Mainly used to extend Microsoft Office Software such as Excel The function of .Visual Basic for Applications（VBA） yes Visual Basic A macro language of , It's Microsoft that has developed and implemented common automation in its desktop applications （OLE） The programming language of the task . Mainly can be used to expand Windows The application function of , In particular Microsoft Office Software .

Where to record macros ？
1、 We can do it in Excel There is a small record macro button on the far left of the status bar , Press this button to start recording macros . If you don't see this small button in your status bar , You can right-click on the status bar , Check record macro in the pop-up menu .

2、 On the far right of the View tab in the ribbon , There is also a button to record macros , Click the drop-down to view 、 Record macros and set relative references .

3、 Macro actually belongs to VBA One of the tools , So we can “ development tool ” Tab find it , Because this tab is hidden by default , So the first step is to enable tabs . This is the third way .

Record macro
1、 We recorded our first macro with the example of automatic underline . After clicking the record macro button , We can see the macro setting window , I set a shortcut key for the recorded macro in the window Ctrl + Shift + U. After I hit ok , Just perform the steps we need normally . After double underlining the numbers , Click the record macro button in the lower left corner again to stop recording .

2、 Follow the above steps to record our first macro .
Run macro
1、 Recorded macros will have no effect if they are not executed . Next, let's see how to execute a macro that has been recorded .

2、 The first way is to select the cells we need to underline , Then find the view macro... From the macro group in the View tab , Then click Run . In this way, the selected cells are automatically underlined .

3、 Another way to execute macros , Is a shortcut key , This is a more efficient method . Remember the last step , Shortcut keys we set for macros ？Ctrl+Shfit +U, Let's try it now .
Isn't that easy ？ Of course, what we record here is just a simple macro . When entering the recording state, we only did one step . If you do a set of operations , Then you can perform this set of operations automatically . In fact, every button on the interface can be understood as a macro , And that is Excel The built-in shortcut key can also be understood as the concept of macro . With the macro tool, we can define the shortcut keys we want for each operation by ourselves . I hope I can help you ！