Global Static and dynamic variable possible?

[ShieBoon]

Hi all, i need a variable for a date which is static, global, and the value of this variable can be changed via a userform. Is that possible?? :|

Excel 2003
Shie Boon
Thanks

 

[ShieBoon]

I see, okay, i'll try that out and tell you if it works for my situation. Thanks alot rorya.

 

[ShieBoon]

Hi rorya, i've created a new name like you advised and specified a value for it.

Now i am trying to access the value within the name and display that value in a textbox of a userform. Could you tell me the codes for it?

Thanks,
Shie Boon

 

[ShieBoon]

Hi rorya, i have managed to access that value from the name. Now i just need to format that value to a date.

Thanks,
Shie Boon

 

[RoryA]

How did you store it? as a number or a date string?

 

[ShieBoon]

I stored the value into the name as a date. 31/12/11. But it changed into =41274. So i removed the equals sign and formatted in into a date via vba. It works already.

Thank you so much, for your time and efforts to reply me patiently, rorya.

Thanks,
Shie Boon

 

[RoryA]

Glad to help.