Here is a simmered down version of what I want to do:
1) Use the open workbook event to delete all sheets and create new sheets dynamically
2) Add an activeX spinner control to one of the new sheets that I dynamically created
3) Code the spinner control to change the value of cell a1 on the newly created sheet.
I am stuck on #3. Normally the code that drives the control is stored in the worksheet, but in my case, I am dynamically creating the worksheet so the code cannot be stored there. Can I put it in a module or something? How would I do this? Been googling and searching for a couple hours. I'm learning way more than I care to about activeX controls, but no luck on trying to accomplish this.
Thanks!
1) Use the open workbook event to delete all sheets and create new sheets dynamically
2) Add an activeX spinner control to one of the new sheets that I dynamically created
3) Code the spinner control to change the value of cell a1 on the newly created sheet.
I am stuck on #3. Normally the code that drives the control is stored in the worksheet, but in my case, I am dynamically creating the worksheet so the code cannot be stored there. Can I put it in a module or something? How would I do this? Been googling and searching for a couple hours. I'm learning way more than I care to about activeX controls, but no luck on trying to accomplish this.
Thanks!
