Add and remove modules for Excel VBA and insert full process text

Add and remove modules for Excel VBA and insert full process text

Method/Step

1, click the Quick Launch bar Excel program icon to enter the Excel interface to select any cell and press ALT+F11 to enter the VBE interface

2, click the menu bar Insert command in the pop-up active menu click the module command

3, another way to insert the module can be in the project Capital Management manager in the mouse click on the white space right click on the pop-up shortcut menu, select the Insert command level two menu select Module command

4, as shown in Module 1, Module 2, respectively, through the menu bar Insert command and Project Explorer click the right button to create the module

5, if you want to delete the Project Explorer redundant Module 2 or Module 1 first selected in the Project Explorer, click the left mouse button to delete the module and then click on the menu bar File command in the pop-up active menu to remove Module 2 or Module 1

6, or another way to delete a module in the Project Explorer right-click the module you want to remove in the pop-up shortcut menu, select the Remove module command to delete the module and also delete the code program stored in the module

7, the role of the module is stored procedures to add procedures for the module need to first double-click the Project Explorer corresponding module at the top of the interface to display the module

8, on the menu bar click the Insert command in the pop-up menu midpoint process in the pop-up dialog box for the process of a name point click OK

9, this is the point to be determined after the display in the code window of the empty Process code This code can also be manually entered

10, the code written just inserted in the empty process code between the two lines and then click the menu bar run the command run sub-process/user form or press F5 shortcut key at this time interface jump to Excel interface display the following prompt box

11, if you do not understand the location of the code can be mouse click Drag to select the location and then press F1 will pop-up help information

The above is for Excel VBA Add, delete modules and insert the whole process graphics and text detailed, I hope you like!