Search code examples
excelvbacontrolsactivexframe

VBA Excel Activex Frame control containing option buttons, the buttons disappear when I leave Design Mode

I am developing a quotation process with VBA in an Excel Worksheet. I placed an ActiveX Frame control with 2 option buttons inside. As soon as I leave Design Mode, the buttons disappear. I have made sure the buttons are visible, have the correct width and height and I know they are there because I can access them pragmatically. The problem is, I guess, with the Frame control that probably has a bug. Any advice will be greatly appreciated.

Cheers, EOutlook

Solution

  • To add an option button to your frame, right-click the frame and choose "Frame object >> Edit" - add the option button from the toolbox which pops up, not from the Developer ribbon.