I figured this out on my own and wanted to share how I did it so others can possibly benefit in the future.
The below example is a simple message box that will return the values you want based on whichever radio button is selected. The radio buttons are ActiveX objects that I named "Monthly" and "Weekly".
Enjoy!
Code:
Sub execute()
Dim myRange As String
If ActiveSheet.Monthly.Value = True Then
myRange = "Monthly"
ElseIf ActiveSheet.Weekly.Value = True Then
myRange = "Weekly"
End If
If myRange = "Monthly" Then MsgBox "The Range is from " & ActiveSheet.Range("B2").Value & " to " & ActiveSheet.Range("C2").Value, vbOKOnly
If myRange = "Weekly" Then MsgBox "The Range is from " & ActiveSheet.Range("B3").Value & " to " & ActiveSheet.Range("C3").Value, vbOKOnly
End Sub
Bookmarks