VBA private sub in private sub?

[Dimitris254]

Hi all,

i'd like to know if it's possible to nest a private sub in another private sub. I don't want one of the sub to be public or something. The code would looks something like this:

Sub main_sub()
Call sub_parent​
End Sub

---------------------

Private Sub sub_parent()
Call sub_child​

Private Sub sub_child()
...
End Sub

End Sub

The reason i want the sub_child in sub_parent is so that they can see each other's variables.

 

[gallen]

No you can't nest Subs. For each sub to see the variable just declare them at module level. Paste this into an empty code window and run the setvariable macro:

Dim sVariable1 As String

Sub SetVariable()
    sVariable1 = "Here I am"
    ReadVariable
End Sub


Private Sub ReadVariable()
    MsgBox sVariable1
End Sub

 

[pgc01]

Hi

Remark: if you just want to share the variables in the module procedures you can define the variables as Private

Option Explicit
Private s As String

Sub Main_sub()

...

 

[gallen]

This should help you understand scope more

 

[Dimitris254]

yes, i'm aware of the scope of variables and that's what troubled me, but i've seen that if i declare only 2 variables public, then it should be ok

however, a follow up question is: can a private sub call another private sub?

 

[gallen]

Best way is to try it, but yes. My code does just that. The SetVariable sub calls the ReadVariable sub. However they must both reside in the same module