My first Add-in. Everything runs well. (Woo-hoo!!)

In the form, I have eight fields with default values that the user can
change in the form.
These values are set in the form's Load event.
But what if the user decides he wants different default values?
I'd hate to make him have to change all eight values each and every
time!

Can I set the default values in cells in the Add-in?
And read them from there during the Load event?
And set an option in the form to save the values entered into the form
into the Add-in as the new defaults?

Ed

Ed from AZ used his keyboard to write :
My first Add-in. Everything runs well. (Woo-hoo!!)

In the form, I have eight fields with default values that the user can
change in the form.
These values are set in the form's Load event.
But what if the user decides he wants different default values?
I'd hate to make him have to change all eight values each and every
time!

Can I set the default values in cells in the Add-in?
And read them from there during the Load event?
And set an option in the form to save the values entered into the form
into the Add-in as the new defaults?

Ed

Yes. You just need to save the addin anytime users make changes to
those defaults. Of course, updating the addin will cause users to lose
their default values and so I recommend storing the values in a text
file OR use SaveSetting/GetSetting to store in the Registry. This would
persist per user so any updates to your addin would not be a problem
because the userform can load the values from the storage location.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

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

Hi Ed

It's
ThisWorkbook

HTH. Best wishes Harald


"Ed from AZ" wrote in message
...
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

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