Why Modules?

[rahulbassi]

Hi Everyone,
I've created a tool with the help of Excel and VBA.
It is working fine. I've done the coding the Sheet and forms section. But I've not used any Module.
Definitely, me code is a mess....but working fine...
Please explain me with an example why and where do we use Modules....??

 

[VoG]

All code goes in modules. There are different types of modules - for example regular modules, sheet modules and userform modules. See http://www.cpearson.com/excel/WhereToPutTheCode.aspx

 

[rahulbassi]

Thanks for guiding....
Gone through the link too....
still need some more clarification....
Suppose I want a piece of code to run one the click of a command button. Then should i write the code in module or in the form window which opens when I click the button twice in DESIGN MODE..?
If I need to write it in module say Module1.
Then how do I link that code to click event?

 

[rahulbassi]

Actually I think I've been writing the code in Userform Modules......But i want to know about the usage of Regular modules...

 

[VoG]

The code for a command button should go in its userform code module.

A regular module would be use for code like this

Sub test()
Dim i As Long
For i = 1000 To 2 Step -1
    If Range("A" & i).Value = Range("A" & i - 1).Value Then Rows(i).Delete
Next i
End Sub

 

[Mindpsyche]

All userform codes go in the userform module, as in the one that open when you click the command button. All other macros are stored in your regular modules.

Lets say you have a userform. Now the code associated with this userform will be entered in the userform module. But when you want to call the userform through a macro, that macro will be in your regular module.

The best thing would be to spend about an hour and go through the gazillion videos explaining the basics of vba on youtube.

 

[rahulbassi]

Thanks for explaining......I think I'm getting the things now......will surely follow the videos for coding in VBA.....afterall the quality of code too matters.......