calling sub functions

[ronaldmacdonald]

Hello everyone

Ive got a now rather large vba sub called (originally main):
sub main()

I want to break it up into sub proceduresso I may have:
sub main()
sub 1()
sub 2()
sub 3() etc etc.

My question is if sub main () is my top level sub (i.e the first one to execute on entering the macro) how do i call other subs from it and do i need to declare them before sub main, after sub main or within sub main?

Cheers

Ronald

 

[SkipVought]

Hi,

Sub Main()
   MySub1
   MySub2 a1, a2
End Sub
Sub MySub1()
...
End Sub
Sub MySub2(arg1, arg2)
...
End Sub

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[ronaldmacdonald]

Ok Skip thats great, just one other question - where do i define the individual subs variables? Within each sub definition or in the main sub?

Cheers

Ronald

 

[xlbo]

depends if you want the variables to be available to all subs or not. If so, you will need to define them as PUBLIC variables, BEFORE any of your subs Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde

 

[SkipVought]

Look in VBE Help to find a discussion of declarations Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[ronaldmacdonald]

Ok Geoff, so basically global variables are best preceded with public. In that case does private limit variable scope to a given sub? That makes sense to me if it doees.

Ronald


Im having an intensive couple of days with this vba stuff!

 

[ronaldmacdonald]

Good point skip! Thats quite helpful and answered my question..

Thanks

Bill