How to access variables that are declared in private subroutine

Dear Volunteers!

I hope someone will help
My question is the following:

How to access variables that are declared in private subroutine?
I would like to use these variables in modules.
In order to better understanding see of the codes here below .

Thanks for all the answers.

Pan314

'stringInSubWorkBook declarated in ThisWorkbook
'Paste into the modul1
Public Sub TestInModul1()
Select Case stringInSubWorkBook_Open
    Case ""
        MsgBox "stringInSubWorkBook_Open is out of context."
    Case Else
        'Here would be able to access
        MsgBox "stringInSubWorkBook_Open=" & stringInSubWorkBook_Open
End Select
End Sub

'paste into the ThisWorkbook
Public stringInSubWorkBook_Open As String
Private Sub Workbook_Open()
    stringInSubWorkBook_Open = "testString"
    Call TestInThisWorkbook
End Sub

Public Sub TestInThisWorkbook()
    'This is OK.
    MsgBox stringInSubWorkBook_Open
End Sub

You don't access variables from private subs. You need to make them global variables. I'm not sure what your trying to get answers for though, based on the code you provided. Are you trying to access a Sub-routine or a variable? They are two very different things.

So you can access variables from private subs?

Originally Posted by TheWrapperGuy

So you can access variables from private subs?

The variable under discussion is not a variable in a private sub; it's a Public variable in the ThisWorksheet module.

Actually I'm surprised it's necessary to qualify a Public variable but that's what I found when I implemented this code.

Here are the visibility rules (all the ones I can think of):

• A variable declared as Public at the top of a generic Module is visible everywhere in every module without qualification
• A variable declared as Public at the top of a workbook or worksheet Module is visible everywhere in that module without qualification, and everywhere in every other module with qualification
• A variable declared in a Sub is visible only within that Sub
• A variable declared with Dim (not Public) at the top of any module is visible only within that module
• A variable declared in a Sub that has the same name as a variable outside the sub will hide the variable outside the sub. To reference the variable outside the sub you must add the module name as a qualifier.
• A variable declared in a module that has the same name as a variable outside the module will hide the variable outside the sub. To reference the variable outside the module you must add the other module name as a qualifier.

(Note that extant and scope are separate issues from visibility. The rules above address only when a variable can be legally referenced, not what happens when you reference it.)

Originally Posted by skywriter

At the risk of being accused of hijacking, can you elaborate on the highlighted part. I've either had too much coffee or not enough.

What is the qualification part?

A qualification is the name of the parent object followed by a dot.

Unqualified: Range("A8")
Qualified: Sheet1.Range("A8")

I don't know if VBA specifically uses that word but "qualified" is the industry standard term used for this situation in object-oriented programming, or other types of programming where containers can be named explicitly.

Dear All who responded until now!

Probably not I formulated my problem well.
No one can understand me.
The reason for my imperfect English proficiency.
I attach a file. I hope this will be understood.
Is not explicit declaration in the file. I have no idea to this.
Further explanation is in the file.


Thank you for your help even more

Sincerely Pan314