View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Paul is offline
external usenet poster
 
Posts: 108
Default Saving variables in XLA's


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?