I have written code for a userform to be displayed and
give the user the ability to change values by having the
text boxes reference a cell in a work sheet.

The issue I have is that when I save file as an XLA it
modifies the variables while the XLA is running yet it
does not save the new variables if I close and reload the
XLA.

Can this be done without having to create an external
data variable file to be read by the XLA?

there is no implicit ability to save variables. You would need to record
the values some place and make sure they were saved with the file, then
retrieve the saved values when appropriate.

--
Regards,
Tom Ogilvy

"Paul" wrote in message
...

I have written code for a userform to be displayed and
give the user the ability to change values by having the
text boxes reference a cell in a work sheet.

The issue I have is that when I save file as an XLA it
modifies the variables while the XLA is running yet it
does not save the new variables if I close and reload the
XLA.

Can this be done without having to create an external
data variable file to be read by the XLA?

You have to store them somewhere.

You could use a worksheet in the addin and save the addin when that stuff
changes.

You could use that external file.

you could use the windows registry.

Paul wrote:

I have written code for a userform to be displayed and
give the user the ability to change values by having the
text boxes reference a cell in a work sheet.

The issue I have is that when I save file as an XLA it
modifies the variables while the XLA is running yet it
does not save the new variables if I close and reload the
XLA.

Can this be done without having to create an external
data variable file to be read by the XLA?

--

Dave Peterson