Accessing Global Variables defined in ThisWorkbook Module

To the ExcelForum Community,

What I've tried to do is define a global variable upon Excel opening this worksheet. Hence, why the declaration must appear in the ThisWorkbook Module.

The problem is that when I try to access the same variable from a different module, it appears that the information previously stored in the global variable is lost.

I've attached a simplified version of the worksheet. For this to work, I would like Cell E1 and F1 to show the same result when the "Setup" button is clicked.

Appreciate any help!

Hello smz,

You need to qualify your reference. See the bold type in the macro.

Please Login or Register  to view this content.

Hi Leith,

Makes perfect sense - thanks a bunch for this, and even more so for the prompt response!