How do I move code from sheets to modules?

dpaton05

Well-known Member
Joined
Aug 14, 2018
Messages
1,418
At the moment, all my code is stored in two sheets and I want organise my code a little better by moving some of it into modules. I don't know how to move it to modules and have it still work, for instance, have the command button still run the code when it is clicked. How do I do this?
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,564
Office Version
365
Platform
Windows
What type of button(s) are you using?

Is any of the code in the sheet modules for events e.g. Change?
 

Watch MrExcel Video

Forum statistics

Threads
1,099,893
Messages
5,471,333
Members
406,757
Latest member
dizzane

This Week's Hot Topics

Top