+ Reply to Thread
Results 1 to 4 of 4

How to change the text of five different cells by clicking radio button

  1. #1
    Registered User
    Join Date
    01-07-2013
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    64

    How to change the text of five different cells by clicking radio button

    Hi,

    So I have five radio buttons in a spread sheet and basically what I want is that depending on which radio button user clicks, the cell text of five different cells would change i.e. if the user clicks Radio Button 1, the cells B2:B7 would have the following text "engine", "tail", "wing", "nose", "fuselage", and if the user clicks Radio Button 2, the cells B2:B7 would have the text - "fuel", "throttle", etc etc". I dont have any idea how to change the values of multiple cells by clicking one radio button. Any help would be greatly appreciated!

  2. #2
    Valued Forum Contributor Dunc3142's Avatar
    Join Date
    09-05-2007
    Location
    Franklin OH
    MS-Off Ver
    2000 and 2007 and 2010 @ Home & Teach 2010
    Posts
    350

    Re: How to change the text of five different cells by clicking radio button

    I think this is what you are looking for.
    See Attached.
    Attached Files Attached Files
    Last edited by Dunc3142; 03-03-2013 at 09:45 PM.
    Yes it will. we just have to figure out how...
    If I have helped you, PLEASE click the * and add to my Rep.
    Also, if the problem is SOLVED please mark it as so.

  3. #3
    Registered User
    Join Date
    01-07-2013
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    64

    Re: How to change the text of five different cells by clicking radio button

    That's perfect! Thanks!

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

    Re: How to change the text of five different cells by clicking radio button

    Hey ... i wanted to view this attachment for the issue that im facing (http://www.excelforum.com/excel-gene...ked-cells.html) ...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 ...

    Please see if you can post it again (my excel version is 2007) ...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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