+ Reply to Thread
Results 1 to 10 of 10

ActiveX Option Buttons disappeared

Hybrid View

  1. #1
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: ActiveX Option Buttons disappeared

    Interesting way to handle it. The solution I applied to my situation was different than the one I came up with for Aaron, and much simpler. My objects are all linked to cells, and are positioned directly on those cells, so all I need to do is loop through them and reposition to the cell location. This didn't work for Aaron because his objects weren't linked to cells. Here's the code:
    Dim obj As Object
        ActiveSheet.UnProtect
        For Each obj In ActiveSheet.OLEObjects
            With obj
                If Left(.Name, 5) = "Combo" Then
                    .Height = 15.75
                    If .LinkedCell = "#REF" Or .LinkedCell = "" Then
                        MsgBox .Name & " Linkcell = " & .LinkedCell
                    Else
                        .Top = Range(.LinkedCell).Top
                    End If
                End If
            End With
        Next
        ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
    Acts 4:12
    Salvation is found in no one else, for there is no other name under heaven given to mankind by which we must be saved.

  2. #2
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: ActiveX Option Buttons disappeared

    Quote Originally Posted by natefarm View Post
    My objects are all linked to cells, and are positioned directly on those cells, so all I need to do is loop through them and reposition to the cell location.
    My applications use a similar naming technique that includes the cell address. I usually use a Class event handler for 'Active X'. The cell address in the name makes it easy for the Event Handler to take appropriate action.

  3. #3
    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. 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. 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