+ Reply to Thread
Results 1 to 10 of 10

ActiveX Option Buttons disappeared

Hybrid View

aaron_burr ActiveX Option Buttons... 08-11-2015, 11:57 AM
natefarm Re: ActiveX Option Buttons... 08-12-2015, 10:25 AM
aaron_burr Re: ActiveX Option Buttons... 08-12-2015, 11:20 AM
natefarm Re: ActiveX Option Buttons... 08-12-2015, 02:09 PM
aaron_burr Re: ActiveX Option Buttons... 08-13-2015, 08:56 AM
natefarm Re: ActiveX Option Buttons... 08-13-2015, 10:38 AM
LJMetzger Re: ActiveX Option Buttons... 08-14-2015, 08:16 AM
natefarm Re: ActiveX Option Buttons... 08-17-2015, 11:06 AM
LJMetzger Re: ActiveX Option Buttons... 08-17-2015, 11:47 AM
Sgt Rock Re: ActiveX Option Buttons... 12-10-2018, 02:42 PM
  1. #1
    Registered User
    Join Date
    08-02-2012
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    44

    Re: ActiveX Option Buttons disappeared

    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
    Last edited by Sgt Rock; 12-10-2018 at 02:45 PM. Reason: punctuation, subject-verb agreement

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Activex frame hides option buttons - Xl 2007
    By Richard Buttrey in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-18-2018, 01:32 PM
  2. Excel: macro and customized buttons have disappeared
    By Stude in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-22-2015, 03:30 PM
  3. [SOLVED] Disabling an Entire Frame with Option Buttons if other Option Buttons are not clicked.
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-20-2012, 04:07 AM
  4. Min/Max buttons have disappeared
    By XTC in forum Excel General
    Replies: 6
    Last Post: 01-26-2008, 08:55 PM
  5. [SOLVED] Macro buttons disappeared
    By Patti in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-09-2006, 02:25 PM
  6. [SOLVED] ActiveX Option Buttons all act as one group
    By quartz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-31-2005, 12:06 AM
  7. [SOLVED] Auto fill option box disappeared
    By sbrimley in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-04-2005, 12:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1