Radio Buttons- VB Excel

First off, I want to thank you  for all your help!!

Second, I have asked a similar question like this one but I still can't get it right and how I want it to turn out.

I have a form object in the excel macro asking a user for a start date then from there they have a choice between 3 months, 6 months, 9 months and 12 months (this meaning if the user would chose 3 months, then 3 months would show up from the 'month' of the start date entered by the user - (i.e., if the start date was Jan 1, 2007... and 3 months was chosen- Jan, Feb, March would show up). The months (celendars) are on an excel worksheet and are 'hand' made... each box is a date (January1, January2 and so on...) and then I highlighted the whole month and named it "January, February, March- or which ever month was highlighted so that each would have its own individual name to be identified by.

So what I need to happen is when the user choses the radio buttons- I want which ever option they chose to come up on excel (i.e., if the start date was Jan 1, 2007... and 3 months was chosen- Jan, Feb, March would show up).

I have this so far but I can't figure out what is going on... I think I have too much involved in the code for just this little piece of work.

Private Sub commandbutton1_Click()
Dim i As Integer
Dim mRange As Integer
i = 1
For Each c In Me.optgroupmonths.Controls
    If c.Value Then
        mRange = 3 * i
        Exit For
    End If
    i = i + 1
Next c

If mRange = 0 Then
    MsgBox "Please Select a month range 3, 6, 9 or 12"
Else
    Application.Workbooks("hg.XLSM").Worksheets("sheet3").Select
    -----------------------------------------------------------------------------THIS IS WHERE I DON'T KNOW HOW TO ACTUALLY IDENTIFY THE X MONTHS CHOSEN....
End If
End Sub

I also want to apologize if this is confusing. I am trying to explain it to the best of my ability...


Thanks again!