ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Active X frame on worksheet (https://www.excelbanter.com/excel-programming/279006-active-x-frame-worksheet.html)

JC[_6_]

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!


All times are GMT +1. The time now is 08:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com