Hi, can one Public variable declared in one workbook be available in all workbook?
in book1.xlsm
Code
[/FONT][FONT=Courier New]Option ExplicitPublic Ans As StringSub started()Ans = "Hi"MsgBox AnsEnd Sub[/FONT][FONT=Courier New]
[/FONT]
in book2
Code
[/FONT][FONT=Courier New]Sub secondsMAcro()[/FONT][FONT=Courier New]MsgBox AnsEnd Sub[/FONT][FONT=Courier New]
[/FONT]
It gives blank msgbox why?
I want it to be able to transfer this value from book1 to book...
Please clarify this for me.
Thanks for helping.