T
The poster formerly known as Colleyville Alan
It has been a few years since I wrote much code for Excel, so I am at a loss
with something that, IIRC, is fairly simple.
I added some radio button ActiveX components to my spreadsheet, and
double-clicked on them to open the editor and put some simple code there. I
noticed later on that when I opened the VBA editor, there was no module for
the code. I looked around and saw that Excel had the code in the
spreadsheet object.
So I added a module and cut/pasted the code to that module. Now the radio
buttons do not work - they are not looking in the module for the code.
Question: how can I get those objects to look in the module for the code
rather than the spreadsheet object?
Thanks
Alan
with something that, IIRC, is fairly simple.
I added some radio button ActiveX components to my spreadsheet, and
double-clicked on them to open the editor and put some simple code there. I
noticed later on that when I opened the VBA editor, there was no module for
the code. I looked around and saw that Excel had the code in the
spreadsheet object.
So I added a module and cut/pasted the code to that module. Now the radio
buttons do not work - they are not looking in the module for the code.
Question: how can I get those objects to look in the module for the code
rather than the spreadsheet object?
Thanks
Alan