Ok then. I've had a look in the forum and cant find what I need.

So...

I want to reference the value of a group of option buttons.

e.g.

I have two groups of option buttons.
One is:

week1,W2,W3,W4,W5.
I also have a command button attached to the worksheet.

I want to reference on the click event of the button the option value that is selected.

Is there a 'clean' way of doing it?

The only other option I have is by iteratively checking each control like so..

With Me
If Week1 Then
CommitTime 7, True
ElseIf Week2 Then
CommitTime 8, True
ElseIf Week3 Then
CommitTime 9, True
ElseIf Week4 Then
CommitTime 10, True
ElseIf Week5 Then
CommitTime 11, True
End If
End With