+ Reply to Thread
Results 1 to 3 of 3

Resetting all radio buttons within a worksheet

  1. #1
    Registered User
    Join Date
    02-20-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    5

    Resetting all radio buttons within a worksheet

    Hi everyone, I am creating scorecards for our company and ratings are inputted using radio buttons (form control). I have a "clear" macro that clears all fields and radio button values (none is ticket). This macro is called throughout different sheets, as different roles in the company have different KPIs and should be on different sheets. I need a code that detects all radio buttons within a certain sheet and clear their values. I cannot put specific radio button names, as I have a lot.

    Please help. Thanks!

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,610

    Re: Resetting all radio buttons within a worksheet

    With forms control radio buttons, you use a reference cell, so you can use some (hidden) columns at the far right of the sheet, actually the last ones. Then your macro only need to clear those columns without tracking actual buttons.Use the same reference columns on all sheets
    Edit: Actually, you could use the same sheet for ALL the buttons and hide it.
    Attached Files Attached Files
    Last edited by protonLeah; 02-25-2013 at 07:26 PM.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    02-20-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    5

    Wink Re: Resetting all radio buttons within a worksheet

    Thanks protonLeah!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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