Can we have multiple Sub and End Sub in a single VBA Code?

[An Quala]

Hello, a very basic question, Can we have multiple Sub and End Sub in a single VBA Code? Is yes, then when should we use multiple sub end sub because I am combining multiple codes written by different people I think it's a good idea to have sub end sub with each one,

Thank you.

 

[Fluff]

No you cant.
As I said in a previous post don't bother combining them into one macro, just call them from another.

 

[An Quala]

No you cant.
As I said in a previous post don't bother combining them into one macro, just call them from another.

Hi, I need to have all in a single code, I will try.

 

[Fluff]

I need to have all in a single code

Why?

 

[vw412]

Do you mean you want to put multiple subroutines (Sub...End Sub blocks) in a single code module? If that is so then yes you can. However, if you are combining code from multiple places you might consider placing each code set in separate code modules to help in organizing them.

If the code you seeking to combine was not written as a Sub...EndSub block originally then you may have other concerns to worry about. It sounds to me like you need more help with code organization.

 

[mehidy1437]

Why?

I think OP is meaning to keep multiple Sub in a single module. Which should be okay.

 

[Fluff]

Judging ny this & other threads, the OP is trying to combine multiple subs into a single sub, not into a single module.

 

[An Quala]

I want to have one single trigger to run all the codes, but as you suggest to save each of them separately and call them in a single SUB would be too messy I think.

 

[Fluff]

I would disagree, but it's your decision.