+ Reply to Thread
Results 1 to 8 of 8

An option button on my userform has vanished

  1. #1
    Registered User
    Join Date
    04-01-2016
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    56

    An option button on my userform has vanished

    I was making a minor adjustment to the positioning of an option button on my userform, and it vanished. I can't see it if I open the form (with scrollbars on), or by tabbing through the elements. I checked the dropdown in the properties window, and it no longer lists the option button as existing.

    So I assumed that I had accidentally deleted it, so I tried to re-create it, but when I do I get the ''ambiguous name, can't call it that" error, as if the option button with that name is still there. I really don't want to have to make a new one and go through all the code that refers to that button and change it, does anybody know how/if there is anything I can do? It has been irritating me for an hour now.

    Thanks.

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: An option button on my userform has vanished

    Hi,

    Do you have any container controls like frames or multipages on the form?
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    Re: An option button on my userform has vanished

    If near any other item its usually found to have become part of the other item....I enlarge the userform so I can move elements around to see if I can locate it...painful and annoying exercise

  4. #4
    Registered User
    Join Date
    04-01-2016
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    56

    Re: An option button on my userform has vanished

    Quote Originally Posted by xlnitwit View Post
    Do you have any container controls like frames or multipages on the form?
    Thanks for the reply, yes, there is a frame on there, and it was near to the scene of the crime when my option button disappeared. I have moved the frame around all over the place, and it didn't show up.

  5. #5
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    Re: An option button on my userform has vanished

    Have you tried enlarging the frame

  6. #6
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: An option button on my userform has vanished

    Select the frame in the designer and then see if the optionbutton appears in the dropdown list. If it does, it means you dragged it into the frame.

  7. #7
    Registered User
    Join Date
    04-01-2016
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    56

    Re: An option button on my userform has vanished

    Quote Originally Posted by xlnitwit View Post
    Select the frame in the designer and then see if the optionbutton appears in the dropdown list. If it does, it means you dragged it into the frame.
    That was it, thank you! You saved me a big headache.

  8. #8
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: An option button on my userform has vanished

    You're welcome. Thanks for the rep.

+ 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. Replies: 6
    Last Post: 07-15-2017, 09:54 AM
  2. UserForm option button bug?
    By aarona in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-08-2017, 04:03 AM
  3. [SOLVED] userform option button
    By adamheon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-26-2016, 09:28 AM
  4. UserForm Option Button Help...
    By z-eighty2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-30-2013, 10:17 PM
  5. Userform option button help
    By mecharissa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-01-2012, 04:48 AM
  6. Userform Option Button to Show/Hide Another Option Button on same Userform
    By R_S_6 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-26-2010, 09:44 AM
  7. Userform controls suddenly vanished
    By madhg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-19-2009, 08:00 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