Global Variable in Excel VBA

[loopoo]

Hi!

Please help me on the following issue:

I want to declare a global variable in an Excel workbook.

I used
"Public zIND As Boolean"

in the code for "ThisWorkbook".

But when I try to call its value, that is assigned on the workbook open event, I can't see it or change it from another sheet code - I want to change its values when a change occurs in a worksheet, but it's not possible because it seems that I can't see it from another worksheet.


Thanks in advance,
Chris

 

[macleanb]

I always define my globals in modules - seem to have no issues when doing it this way...

 

[loopoo]

Thanks a lot for your help.
It's working now.

Chris