I am by no means an Excel Guru. However, I did find after searching and searching a possible answer to your question. I will reiterate, just to be clear for this happened to me. I wanted to use ActiveX
controls due to flexible formatting. I wanted to use ActiveX options - radio buttons. I wanted to group 5 related ActiveX radio buttons together - hence I found out about adding a Microsoft Frame for ActiveX controls = Developer > Insert > ActiveX controls > lower right pick more options > scroll down to Microsoft Frames 2.0 - select it and draw the desired size frame on your worksheet. Apparently, you just cannot simply insert an ActiveX option control or any other ActiveX control into that frame. YOU HAVE TO EDIT THAT FRAME AS I FOUND OUT - VIOLA! So, draw your frame the size you want. With the frame selected, right click on the frame, select Frame Object, select Edit. Guess what, a Tool box appears with your controls. Pick the one you want and now draw it in your Frame. Not sure if the attached image came through but this is what you should see. Now, when you leave design mode you'll still see your control button. Whew! this was an all morning affair, I hope I have saved some hours of Googling!
Happy Holidays to All!
MEW
2018-12-10_12-37-34.jpg
Bookmarks