+ Reply to Thread
Results 1 to 2 of 2

Userform frame allowing 2 radio buttons to be clicked at the same time (and other issues)

  1. #1
    Registered User
    Join Date
    11-27-2017
    Location
    Surrey, England
    MS-Off Ver
    Office 365
    Posts
    65

    Userform frame allowing 2 radio buttons to be clicked at the same time (and other issues)

    Hi all,

    I've been having a few random little glitches on my VBA userform this year which never happened last year and they're really confusing me. For instance, my colleagues using my form have been able to somehow occasionally click both radio buttons within the same frame, when it is designed by nature to auto un-click one if they click the other. Additionally, some have noted that even when they click some buttons or into some text boxes, they just don't select or allow typing. Finally, there have been cases where one of the popups within the form (if you click a button) doesn't close but still allows you to continue submitting data in the form. It is weird that the popup is just chilling in the background as it usually prevents the user doing anything else. All glitches seem to be fixed randomly by clicking around and just 'waiting' for it to fix and then they can click them with the correct functionality again.

    The fact that the glitches are not resulting in an error and are fixing themselves after random clicks are made, make me wonder what I can possibly do to fix them? Seems like a glitch but can't work out why? The only difference is, we are all remote working and there have been some ongoing issues with our VPN/Remote connection cutting out briefly and coming back, causing our network drives to disconnect (which is where the files are stored) - could this be a factor?

    Double Radio Button.jpg

    I've attached a dummy version with no company data and randomised numbers etc inside, so that you can see the code and see if there are any fixes I can try? Any help would be amazing and much appreciated!!!
    Attached Files Attached Files
    Last edited by Izzii0x; 07-07-2020 at 12:20 PM. Reason: Adding to title

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

    Re: Userform frame allowing 2 radio buttons to be clicked at the same time (and other issu

    Hi Izzii0x,

    Intermittent problems are almost always the most difficult to diagnose. I was unable to duplicate your problem as you probably expected.

    Your code does not do anything hideous that I could find.

    The two OptionButtons your are having problems with are not in a Group. Even though the OptionButtons are in a Frame and the Frame should take care of the 'lack of Group', you may want to try putting those two OptionButtons in a Group (and even try eliminating the Frame temporarily - as the Frame is only necessary if there is no group).

    Lewis

+ 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. Show UserForm with Continue/Cancel buttons, allowing user to edit sheet
    By dancing-shadow in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 01-16-2017, 05:33 AM
  2. [SOLVED] Show UserForm with Continue/Cancel buttons, allowing user to edit sheet
    By dancing-shadow in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-10-2017, 06:48 AM
  3. Userform calculator only performing the last 2 buttons clicked.
    By Zimmerman in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-17-2016, 01:47 PM
  4. [SOLVED] VBA Radio buttons that select multiple UserForm check boxes
    By Darkenergyz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-14-2014, 12:13 PM
  5. [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
  6. userform with frame and option buttons
    By erich_7719 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-25-2008, 11:57 AM
  7. Userform Radio Buttons
    By neodjandre in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2007, 09:49 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