+ Reply to Thread
Results 1 to 3 of 3

How to connect User Form Radio Button to Radio Buttons in Workbook

  1. 02-10-2022, 07:26 AM #1
    cameronadill
    cameronadill is offline
    Registered User
    Join Date
    02-02-2022
    Location
    Vegas
    MS-Off Ver
    Office 365
    Posts
    51

    How to connect User Form Radio Button to Radio Buttons in Workbook

    I am trying to link radio buttons from a userform so that when Option 1 is selected in the userform, Option 1 will also be selected on both Sheet 1 & Sheet 2 of my workbook. When 1 option is selected, the other two options will not be selected. Both Sheet 1 & Sheet 2 should match the option selected in the userform.

    I have tried so many diffferent variations of the code below but I'm still missing something. Any help?

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-10-2022, 07:41 AM #2
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: How to connect User Form Radio Button to Radio Buttons in Workbook

    You have a continuation character after the THEN of the IF test.
    This means only those 3 lines are conditional. All the other lines are executed.

    The is modification

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info
    Reply With QuoteRegister To Reply
  3. 02-10-2022, 07:43 AM #3
    cameronadill
    cameronadill is offline
    Registered User
    Join Date
    02-02-2022
    Location
    Vegas
    MS-Off Ver
    Office 365
    Posts
    51

    Re: How to connect User Form Radio Button to Radio Buttons in Workbook

    Nice easy fix.

    Andy, you're my hero. Thank you.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Using Radio buttons and Check box on a user form
    By deek in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-18-2020, 12:48 PM
  2. Form and radio buttons
    By axm1955 in forum Excel General
    Replies: 3
    Last Post: 12-22-2017, 03:12 PM
  3. Conditioned radio-buttons form
    By udi1234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-26-2014, 03:37 PM
  4. How to insert and user of Buttons, Radio buttons, check boxes in excel sheet.
    By krishco in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-03-2013, 02:52 AM
  5. [SOLVED] Form w/ Textbox/Radio buttons/Checkbox and button to transfer to 2nd sheet as database
    By christlivethinme in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-27-2013, 02:24 PM
  6. [SOLVED] Macro with pop up user input and radio buttons
    By schmidt62 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-03-2012, 05:45 PM
  7. Form w/ Radio Buttons
    By eforti in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-12-2007, 05:11 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1