View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bura Tino Bura Tino is offline
external usenet poster
 
Posts: 57
Default Persistent data in an Add-in

Hi,

Is it better to use a global variable or a cell in an add-ins worksheet to
store a value?

Using a global variable seems cleaner, but I'm concerned that the project
may get reset and the value would be lost.
Using a cell in a worksheet seems ugly, but so far seems to work for me.

Are there any hidden dangers in the latter approach?

Thank you,

Bura