Add-in question: can I store default values for a form in the Add-in?

E

Ed from AZ

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
 
G

GS

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
Click to expand...

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.
 
E

Ed from AZ

Yes. You just need to save the addin anytime users make changes to
those defaults.
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting default value property in form 1
add a chart in a Add-In 1
capture filter values from a sheet into a dropdown list in userfor 3
How do I change a function's otional parameter default values programmically 5
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Storing VBA Code In a Cell to Use real Time 2
Retaining Values in Userform when called a second time 2
Run select query from VBA code where criteria comes from a multi select ListBox 2

Top