Public variable not seen by event module.

[Roopher]

Hi together!

Having searched the forums I go crazy now with the following unsolved situation:

I declare a public variable in a *standard module* to be used throughout the project. I can use that variable in that module.
---
Option Explicit
Public psWorkbookName As String <-------------This one here!


Private Sub AddCompanySheet_Click()
code here
---


But, when I like to use that same variable within the *workbook event module* (Workbook_Deactivate() or the like), it is not recognised: autocomplete does not work, 'Variable not defined' error when runnig/compiling.
---
Option Explicit


Private Sub Workbook_Deactivate()

psWorkbookName = ActiveWorkbook.Name

End Sub
---


What is the big flaw here? Declaring the public variable in the event module's declaration section gives the same error the other way around: the standard module's procedures won't recognise it! Anyone can help???

 

[RoryA]

If you can't access a public variable then I would guess it is not in fact declared in a normal module, it is in a class module. (the fact that you showed what looks like an event procedure below it would tend to confirm that).

 

[Roopher]

Thank you so much, rorya!

You are right. Is works now! I had had the variable declared in the Sheet1 - module, not in a standard module, stupid me LOL...

Since I skipped the chapter with the class modules in the textbook because I did not get the concept, I never thought that I would have "class modules" in my workbook. Obviously, the modules in Sheet1, Sheet2 etc are all class modules! What a surprise!