Save User Data in My Add-In

[anthonya2369]

I have developed an add-in that all my colleagues use. There are certain add-in features that I would like the users to be able to change. For example, I allow for a selection of cells and they can place the IfError formula into those selected cells. I have it default to the return value of 0 if there is an error. I want the user to be able to change the default value to soemthing other than 0 if they so choose. Where can I save this value so I can look it up later? I rather not create a text file and place it there or an .ini file but I guess I can do that. I was hoping to place it in the add-ins sheet page but the workbook doesn't show up under the workbooks section, just the add-ins portion. Just wanting to know what the standard is?

I have never used xml files for this but maybe this would be a considered approach and I can open my abilities more by learning?

 

[anthonya2369]

I think I figured it out. I will find out tomorrow. It has to be done like this:

Application.AddIns(8).Application.Worksheets("Sheet1").Range("a1").Value

I can choose any cell, I shall find out at work. I guess sometimes, it pays to play around and keep trying...