I am writing VBA code in an Excel spreadsheet. I would like to have the code in a module run to a certain point and then invoke a Userform that contains radio buttons. I would like to have the user pick an option among the radio buttons and then click a command button that will either unload the Userform or hide it. How do I pass the value from the selected radio button back into the code that is running in the module? What I would like to do is have a series of if-then statements which would examine what radio button was selected, and then branch to different actions depending on the radio button selection. To keep the project simple, I don't want to have the if-then statements reside inside the code for the Userform itself.
Thanks very much.