Your suggestion of a user form is a good one. You could set the change
event of your option A radio button to enable the radio buttons for
options D, E & F.

Something like

Private Sub OptionButton1_Change()
If OptionButton1.Value Then OptionButton2.Enabled = True Else
OptionButton2.Enabled = False
End Sub

Remember to put the option buttons in different frames


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=540387