R
Risky Dave
Hi,
I have a sheet with questions on it, each on a separate line. associated
with each questions is a set of Control Buttons configured so that only one
button can be selected per question. The selected button is used to drive a
conditionally formatted cell also associated with each question, so that, or
example, if option 3 is selected the formatted cell turns red.
This is all easy enough and is working, with each Contol button assocuiated
to a unique cell and part of a group that relates to it's specific question.
Is there any way I can copy a configured row of these buttons so that the
properties will auto adjust the cell references and group names (in much the
same way that you can drag and copy cell, formats etc)?
The reason I ask is that I have about 500 questions I need to set up and
don't much fancy manually editing each buttons properties box :-(
TIA
Dave
I have a sheet with questions on it, each on a separate line. associated
with each questions is a set of Control Buttons configured so that only one
button can be selected per question. The selected button is used to drive a
conditionally formatted cell also associated with each question, so that, or
example, if option 3 is selected the formatted cell turns red.
This is all easy enough and is working, with each Contol button assocuiated
to a unique cell and part of a group that relates to it's specific question.
Is there any way I can copy a configured row of these buttons so that the
properties will auto adjust the cell references and group names (in much the
same way that you can drag and copy cell, formats etc)?
The reason I ask is that I have about 500 questions I need to set up and
don't much fancy manually editing each buttons properties box :-(
TIA
Dave