' get the index of the active OptionButton in an arrayFunction OptionButtonIndex(optArray As Object) As Integer Dim ctrl As Control ' this means not found OptionButtonIndex = -1 For Each ctrl In optArray If ctrl.value Then OptionButtonIndex = ctrl.Index Exit For End If NextEnd Function