Excel macro - divide procedure into more subs

Question

My procedure has become too large and won't run anymore. I've redesigned my code in my mind, but I need to get my current code up and running before I start editing. I've looked online and they say you need to split your procedure into subs and call them, but none really explain or show how you do this.

Thanks!

Possible duplicate of http://stackoverflow.com/questions/3751263/procedure-too-large-in-vba — barrowc, Apr 30 '11 at 03:54

score 2 · Accepted Answer · answered Apr 29 '11 at 15:21

2

Sub Sub1()
    ' Code...
End Sub

Sub Sub2()
    ' Code...
End Sub

Sub Main()
    Sub1
    Sub2
End Sub

answered Apr 29 '11 at 15:21

Chris Trombley

2,232
1
17
24

score 2 · Answer 2 · answered Apr 29 '11 at 15:31

2

The first step is to take parts of code that are duplicated, and created one subroutine or function that you put that part into. Then you call the subroutine or function instead of duplicating the code everytime you need it.

answered Apr 29 '11 at 15:31

Lance Roberts

22,383
32
112
130

score 0 · Answer 3 · edited Dec 06 '20 at 01:33

0

Sub MacroName

Call ProcedureName1
Call ProcedureName2
etc...

End Sub

Sub ProcedureName1
'insert your vba code here

End Sub

The Call statement pulled each of the subs as long as I called the correct named sub.

edited Dec 06 '20 at 01:33

Dharman

30,962
25
85
135

answered Dec 06 '20 at 01:27

Deniz Balta

11
1

Excel macro - divide procedure into more subs

3 Answers3