How do I move code from sheets to modules?

dpaton05

Well-known Member
Joined
Aug 14, 2018
Messages
1,476
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

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,654
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,102,335
Messages
5,486,239
Members
407,538
Latest member
kbendelac

This Week's Hot Topics

Top