Copy module VBA

giupviecnha

New Member
Joined
Nov 13, 2018
Messages
1
Have a module in VBA Project. How can I quickly copy the whole module and create a new one with a different name.

If I right click the module their is no copy option?
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

footoo

Well-known Member
Joined
Sep 21, 2016
Messages
3,012
Office Version
2016
Platform
Windows
Insert a new module (and name as required).
Open the original module and go to Edit/Select All.
Right click and copy.
Open the new module and paste.

(Why would you want to make a copy of a module in the same workbook?)
 

Watch MrExcel Video

Forum statistics

Threads
1,099,043
Messages
5,466,191
Members
406,472
Latest member
QuarkJaguar

This Week's Hot Topics

Top