View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier[_12_] Jon Peltier[_12_] is offline
external usenet poster
 
Posts: 8
Default Add-in question: can I store default values for a form in theAdd-in?

Don't ignore Gary's suggestion NOT to store data in the add-in.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 9/27/2010 3:13 PM, Ed from AZ wrote:
Yes. You just need to save the addin anytime users make changes to
those defaults.


Thank you for the response.
Is there a Userform.Parent or similar that gets the add-in workbook?
I looked, but I couldn't find such a thing.
Could build a string from the ground up with the add-in name if I have
to.
It would be easier if there was a simple property.

Ed