which module to use

[hitch_hiker]

One of my workbooks has become corrupted, I printed all the vba, and now I have to retype it all, do I need to put each back into the modules or can I just write each sub one after each other in one module?

 

[My Aswer Is This]

You can put them all in the same Module if you want.

Your Module would look something like this:

Sub Hello()
MsgBox "Hello"
End Sub
Sub GoodBye()
MsgBox "GoodBye"
End Sub
Sub Dads_Home()
MsgBox "Lets all hide"
End Sub

 

[Michael M]

Making sure of course that any that are sheet related go into their respective sheets
AND
any that are workbook related, like Workbook_open, for instance are in the This Workbook Module

 

[i_nth]

There may also be issues with variable and procedure scope within and between modules. i.e. global vs module variables, Private vs Public, etc.
The safest approach is to replicate the original module structure and put the code exactly where it was before.

 

[My Aswer Is This]

You said:

I printed all the vba, and now I have to retype it all,

If you put all the code into A Word Document for example and then printed it out.

Just copy the code from the Word Document and paste it in the Module.

No need Retyping it.


​