Returning the checked Range Reference from a UserForm

I have a lot of macros in my Personal that are variations on a theme. They can alter something with a range. I have (but don't want) separate macros for the Activesheet, the selected range, the whole workbook, all workbooks, etc. I got the bright idea today to make a multipurpose Range Chooser form to determine which range to use, for the purpose of feeding that range to any of my macros that need it.

With that said, I've gone as far as I can go on my own comfortably. I'm stuck at how to determine which of my checkboxes has been checked so I know which range to use to feed to my macros.

Related to that, how do I limit my users to one and only one checkbox?

Any help is appreciated, and if you have a better idea for how to do this, I'm wide open to suggestions.

Thanks!

Hello jomili,

I have not looked at your sample Workbook yet, but you seem to be so clued up with what you are doing, that it makes me wonder, why don't you use Option Buttons instead of CheckBoxes?

Regards

Post somehow duplicated, and now deleted.

Probably because I forgot about Option Buttons. Pursuing that now. "Clued up"? Does that mean I seem to know what I'm doing? I NEVER want to give that impression

Well, option buttons were DEFINITELY the way to go. Thanks for the clue!

You are welcome jomili,

I am glad that you managed to Solve your own issue, and thank you for the Rep+. I appreciate it!

Regards.