Call Code in One Module Into Another

Hi All,

Could anyone give me a simple example of how you call code from one module into another. I would like to try making different modules containing different code. Then some how use the code from one module in another one. thanks - SEOT

Hello SEOT,

It isn't very clear from your post what you want to do. When you say "module", do you mean a Sub or Function or are you referring to a VBA Module? Are the modules in the same workbook or in different workbooks?

Sincerely,
Leith Ross

I have been putting all my code in these things called modules on the visual basic editor, but the start with Private Sub and end with End Sub on each of these. Do you have a simple example of calling code between these things. I hope you understand what I am trying to say here. I have been trying to read a little on how this all works, but I have not figured it all out yet. thank you-- SEOT

I figured it out after playing with it for about an hour now. I use a call procedure and drop the code in a module. Then, I can use the code in the module in other places within the workbook. I appreciate you trying to help me my friend- SEOT