I've been working on some VBA code in a sample spreadsheet. I have 4 command buttons on a new sheet, 4 user forms, and 4 modules. Rather than than manually copy/paste between 2 workbooks, how can I easily export the code from one workbook to another?
Manually copying and pasting now would not be that big of a deal. However, if I ever have to modify the code, I will have likely forgotten a lot of how VBA works, so I need a mostly automated process.
I found Chip Pearson's article about doing that sort of thing, but it's more like a textbook than a usable process or procedure.
Is there a built in function, or some easy way to do this? Ideally, I would like for this process to be accomplishable by a nonprogrammer techie person.
Bookmarks