Consulting

Results 1 to 3 of 3

Thread: Depending on the marked radio button, the text in the cell changes

  1. #1
    VBAX Regular
    Joined
    Jan 2021
    Posts
    65
    Location

    Depending on the marked radio button, the text in the cell changes

    Could someone please help me with the following. In a group I have three radio buttons with options A, B and C. In cells D2, E2 and F2 I have text that I would like to copy to cell I2 depending on which radio button is checked. For example, if radio button B is marked, then the text from cell E2 should appear in cell I2. Thank you.
    Attached Files Attached Files

  2. #2
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,844
    Link the cell of one of the three option button to a cell (I used A8). All the buttons in that group will be linked to the same cell.
    Formula in I2:
    =INDEX(D2:F2,A8)
    Attached Files Attached Files
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

  3. #3
    VBAX Regular
    Joined
    Jan 2021
    Posts
    65
    Location
    Great. Thank you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •