View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JC[_6_] JC[_6_] is offline
external usenet poster
 
Posts: 1
Default Active X frame on worksheet

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!