Sock
08-07-2013, 07:29 PM
Hi everyone,
When I've developed code within a workbook, I had an options menu userform made, which would have preferences saved into a worksheet and then those options would be pulled from that sheet. This seemed to work fine, as it would enable the user to have different sets of options made for each workbook they used this in. However, when I finally put my code into an add-in, I realized it doesn't work as smoothly as I would have hoped. Ie. I had no idea what I was doing (and still don't!) :(
This add-in is to be used across any workbook.
So here's the question:
If I want to make an options menu that can save option preferences within a workbook for this add-in, what would be the best way to go about doing this?* It seems like worksheets can't be created and used with an add-in like they can be with a regular .xls/.xlsx file. Any suggestions?
*For example, a user may want to use "Algorithm Type A" and they select this from the options menu. Then if in a different workbook they run the add-in and select "Algorithm Type B" instead.
As usual, your help is GREATLY appreciated. Please let me know if any more detail is required.
When I've developed code within a workbook, I had an options menu userform made, which would have preferences saved into a worksheet and then those options would be pulled from that sheet. This seemed to work fine, as it would enable the user to have different sets of options made for each workbook they used this in. However, when I finally put my code into an add-in, I realized it doesn't work as smoothly as I would have hoped. Ie. I had no idea what I was doing (and still don't!) :(
This add-in is to be used across any workbook.
So here's the question:
If I want to make an options menu that can save option preferences within a workbook for this add-in, what would be the best way to go about doing this?* It seems like worksheets can't be created and used with an add-in like they can be with a regular .xls/.xlsx file. Any suggestions?
*For example, a user may want to use "Algorithm Type A" and they select this from the options menu. Then if in a different workbook they run the add-in and select "Algorithm Type B" instead.
As usual, your help is GREATLY appreciated. Please let me know if any more detail is required.