+ Reply to Thread
Results 1 to 16 of 16

Challanging prob with radio button and Locked cells

  1. #1
    Registered User
    Join Date
    11-17-2014
    Location
    Bangalore
    MS-Off Ver
    2003
    Posts
    9

    Question Challanging prob with radio button and Locked cells

    Hi ...

    It is pretty urgent and requesting you to give me a solution on the following issues im facing with Excel:

    1. There are 3 columns(A, B & C) and in each column, i have five cells(rows) with some text on top of which i have added Radio buttons on all those cells. It is like when someone click on the second cell(A2's radio button), then the value '2' should display in the resultant final cell(which is 6th cell on the same column). Likewise, i have five radio buttons in each column with one final resultant cell to display the value. (Please refer the attached IMAGE) ...

    This works fine with Column A but the problem is when i select the Column B's first option (i.e)., B1 radio button, the resultant final value turns as '6' in the A column's resultant cell. I want it like any radio button selected in Column A should display the result value only in column A's resultant cell and the same logic with Column B & C .... but currently, the radio buttons starting from B column till the end of C column is getting counted as continuation of column A's radio options and hence it is displaying the values from 6 to 15 that too in the column A's resultant cell.

    To be precise, select any radio in column A -> resultant value should display in the final result(Score) cell of A column which is any value from 1 - 5.
    select any radio in column B -> resultant value should display in the final result(Score) cell of B column which is any value from 1 - 5.
    select any radio in column C -> resultant value should display in the final result(Score) cell of C column which is any value from 1 - 5.

    I have tried "Right click-Protection TAB-Link cell" etc along with few other options ... but of no help ...


    2. In the same sheet, i wanted to Lock only the resultant cell final(Score) values and hence protected the sheet ... but once protected, it is not allowing me to select the radio buttons/options as those are also getting protected. In other words, i want only the resultant cell to be protected and not the radio buttons ... so that my users will select any radio button and can see the resultant value in the final cell but they should not manually modify the final resultant value.

    I have tried googling many of selecting Locked/Unlocked cell options along with Protection edit user range eMy Sheet.jpgtc .. but of no use ...

    Any assistance on this will be very great help please ....

    Thanks,
    Vijay

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Challanging prob with radio button and Locked cells

    It would probably be easier if you attached the workbook instead of an image.
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  3. #3
    Registered User
    Join Date
    11-17-2014
    Location
    Bangalore
    MS-Off Ver
    2003
    Posts
    9

    Re: Challanging prob with radio button and Locked cells

    Hi Tom ... i have attached the sheet now ... please see if you can help me on this ...
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    11-17-2014
    Location
    Bangalore
    MS-Off Ver
    2003
    Posts
    9

    Re: Challanging prob with radio button and Locked cells

    To be precise, i want to make it as follows:
    select any radio in column A -> resultant value should display in the final result(Score) cell of A column which is any value from 1 - 5.
    select any radio in column B -> resultant value should display in the final result(Score) cell of B column which is any value from 1 - 5.
    select any radio in column C -> resultant value should display in the final result(Score) cell of C column which is any value from 1 - 5.


    In the same sheet, i wanted to Lock only the resultant cell final(Score) values and hence protected the sheet ... but once protected, it is not allowing me to select the radio buttons/options as those are also getting protected. In other words, i want only the resultant cell to be protected and not the radio buttons ... so that my users will select any radio button and can see the resultant value in the final cell but they should not manually modify the final resultant value.

  5. #5
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Challanging prob with radio button and Locked cells

    I've had a look and I noticed that each radio button is using $E:$10 as its cell reference. If you change one of the radio buttons cell reference in columns B or C, it changes ALL the radio buttons to the same cell reference. I'm not sure why it is doing this, but I bet that is at least part of the problem, but, I could also be very wrong
    Last edited by gmr4evr1; 03-22-2015 at 10:52 AM.

  6. #6
    Registered User
    Join Date
    11-17-2014
    Location
    Bangalore
    MS-Off Ver
    2003
    Posts
    9

    Re: Challanging prob with radio button and Locked cells

    Thnx for responding .. Appreciate your effort ...

    Yes you are right ... Tatz one of the reasons i posted it here ... coz i too faced the same issue ... In other words, donno how to control one column's radio buttons only within that column alone ...

  7. #7
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Challanging prob with radio button and Locked cells

    Is there code with this? If so, the code didn't come with the worksheet you attached.

  8. #8
    Registered User
    Join Date
    11-17-2014
    Location
    Bangalore
    MS-Off Ver
    2003
    Posts
    9

    Re: Challanging prob with radio button and Locked cells

    No code on this .. as i believed it can be handled without code, i dint even think about the coding part ... May be you are right that i would've tried it from coding end but im not so good with it ...

  9. #9
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Challanging prob with radio button and Locked cells

    Take a look at this http://www.excelforum.com/excel-prog...io-button.html and look at the attached file in post #2. I tried using a vlookup formula, but was unable to figure it out how, or what cells to reference. Maybe you will have more luck with it?

  10. #10
    Registered User
    Join Date
    11-17-2014
    Location
    Bangalore
    MS-Off Ver
    2003
    Posts
    9

    Re: Challanging prob with radio button and Locked cells

    Heyyy!!!! ... surprised that we are on the same page on thinking ... !!!!

    Yes before posting my issue, i too had a look at the same link that you have referred above and downloaded that attachment... however, for some reason i couldn't open it from my end as it always redirect to Login page and even after entering the credentials, it keep loading the Login page again n again ...

  11. #11
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Challanging prob with radio button and Locked cells

    See if you can get it this way....
    Radio Buttons.xlsx

  12. #12
    Registered User
    Join Date
    11-17-2014
    Location
    Bangalore
    MS-Off Ver
    2003
    Posts
    9

    Re: Challanging prob with radio button and Locked cells

    Thnk you so much ... i can open the attachment now ...

    Not sure if my issue will get fixed but appreciate your followup and response on this .... Thank you again

  13. #13
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Challanging prob with radio button and Locked cells

    No problem. Hopefully you'll be able to make something out if work for you.

  14. #14
    Registered User
    Join Date
    11-17-2014
    Location
    Bangalore
    MS-Off Ver
    2003
    Posts
    9

    Re: Challanging prob with radio button and Locked cells

    No luck yet .... will let you know if i get any solution on this from anyone ... Thank you ...

  15. #15
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Challanging prob with radio button and Locked cells

    Ok, good luck

  16. #16
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Challanging prob with radio button and Locked cells

    Option buttons are working on group. In this case, they are working on worksheet. To seperate into 3 groups, first, delete all current buttons. Then insert a Group box by click on Developer on menu bar , click Insert / Group box (In menu File, choose Option / Customize Ribbon, check into Developer box)
    Move this group box into C5:C9. Insert 5 buttons inside this group box. Assign reference for these 5 buttons.
    Next group box for next column,...
    Quang PT

+ 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. [SOLVED] How to change the text of five different cells by clicking radio button
    By src16 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-22-2015, 11:33 AM
  2. Need VBA code to hide cells if radio button in another cell is chosen
    By sqearly in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-26-2011, 01:10 PM
  3. Pressing one radio button to select another radio button
    By raehippychick in forum Excel General
    Replies: 1
    Last Post: 09-13-2007, 11:30 PM
  4. Can the Combo Box move and size with cells radio button be enable
    By Tom Cote in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 PM
  5. [SOLVED] Can the Combo Box move and size with cells radio button be enable
    By Tom Cote in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 05:05 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