Problem with public global declared variables

I am trying to figure out what I am doing wrong with global/public declarations. In the code I am writing, I have the following code in the “ThisWorkbook”

Please Login or Register  to view this content.

Then in another sheet I have am using the command to transfer the value:

Please Login or Register  to view this content.

The value of HemiRes is always 0, no matter what I seem to do. Is there something I an not correctly understanding about the way I can save values to a public declared variable from any sheet?

Thanks

Put the declaration in a module, not This_Workbook