• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Radio Button Help

TomT

New Member
Using the 'suicide vs. murder' dashboard on the main Chandoo site as inspiration (or blatant copy/paste if you prefer), I'm having issues with the radio buttons for sorting on the 'Output' sheet.

I can link them so that the sorting order works correctly, I just can't figure out how to make the text change based on what's been chosen in the 'Sort List by' dropdown.

Any links to a resource would be greatly appreciated.

I included the excel file for reference.

Thank you,

Tom
 

Attachments

  • mould-and-wet.xlsx
    17 KB · Views: 13
or using VBA to make it Automatic

Add a small code module with
Code:
Sub DropDown1_Change()
Sheets("Output").Shapes("Option Button 2").TextFrame.Characters.Text = Sheets("Mould Vs Wet").Range("I3").Text + " Ascending"
Sheets("Output").Shapes("Option Button 3").TextFrame.Characters.Text = Sheets("Mould Vs Wet").Range("I3").Text + " Descending"
End Sub
Then link the dropdown menu to that code

or see attached file:
 

Attachments

  • mould-and-wet.xlsm
    26.5 KB · Views: 13
The two Option Buttons had different sized fonts, you may want to adjust that
 
Back
Top