2. After the recording is completed, press alt+f 1 1 to switch to the code editing window, set the variable I as a long integer, set a for loop, and add next before the end sub.

3. Press alt+f 1 1 to switch to the excel interface, then record a macro with the title deleted, modify the code, and add a for loop. Press alt+f8 to call the macro window.

4. Call the form button from the view, drag out a button and create a macro for it to generate the payroll.

5. Right-click the Edit Text button to rename it, then add a macro and delete the title bar in the same way, so the operation can be reversed.