This post is better suited for the VBA Programming forum, but here is
what you are looking for hopefully:

Step 1) Open the VBA editor, double click the sheet your controls are
on
Step 2) View Menu - Code
Step 3) Left Dropdown select Question1's No code, then Yes code

Get something like this: (if No for question 1 is selected, they CAN
answer Q2)
-
Private Sub optQ1No_Click()-
OPTQ2YES.ENABLED = TRUE
OPTQ2NO.ENABLED = TRUE
-End Sub-

(if YES for question 1 is selected, they CANNOT answer Q2)

-Private Sub optQ1Yes_Click()-
OPTQ2YES.ENABLED = FALSE
OPTQ2NO.ENABLED = FALSE
-End Sub-


--
crispbd
------------------------------------------------------------------------
crispbd's Profile: http://www.excelforum.com/member.php...o&userid=10880
View this thread: http://www.excelforum.com/showthread...hreadid=273606