Active X frame on worksheet

J

JC

Hi,

Since UserForms are not an option for a Excel tool I am building, I
want to use ActiveX objects directly on a worksheet in stead. One of
the objects I want to place on the sheet is a frame (or group box as
it is sometimes referred to). The problem now is that I can attach
code to the frame on the codesheet, but I cannot refer to the option
buttons I placed in the frame. I even cannot find the names of those
option buttons so I could have referred to them. Does anyone know if
there is a possibility to refer to option buttons in an ActiveX frame
placed directly on a worksheet? I need to put the value of the option
buttins in a cell...

Thanks for the assistancE!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top