Macro can't see a public variable

Hi,

I have declared one variable outside of Sub. And in a Sub I gave it a value. Then I run a macro, which should take that value and print it to the cell. However, it is printing a blank cell, not even "0" (I run a macro and anything in that cell is removed).

my code:

Please Login or Register  to view this content.

and then my macro:

Please Login or Register  to view this content.

Do you know how to make so macro see my variable declared outside of this macro?

Thanks for any help!

Oh, yes, sorry.
I have an ActiveX Controls button "Start" on a sheet. Once I press "Start" Sub init() runs. Then once I press key UP, sub PressUp() runs.

Sorry, I'm not good in this and do not quite know which is a standard module.

Sub init() is placed in the Sheet code. I see that I have Sheet1 under the MS Excel Objects And then I have a macro "Module1" under Modules.

but does it makes any difference how and when Sub init() is called. I was thinking to have one global variable, so it could be accessed from different subs in the same workbook. I see sub init() runs well and sets tileP correctly. But then when I press keyUp on a keyboard, macro Sub PressUp() doesn't show any assigned value. It looks like tileP for Sub PressUp() is not visible.

so, that how it works? Thanks a lot for quick reply.

Then it means that global variables should be declared in a module1 (only) to be visible from all subs?