Linking Option Buttons to Cells

[Risky Dave]

Hi,
I am develping qa questionnaire with something like 120 rows in it. Each row
has 7 possible responses in it. Each response has an options button/check box
associated with it (In don't mind which), but only 1 button can be selected
from each row. The questionnaire therfore has something like 840n option
buttons in it.

So far, so good.

What I want to do is link each button to a unique cell reference, but given
the number of cells, I don't want to have to go into the properties dialogue
of each one and change it manually.

Is there any way of replicating the buttons such that the cell reference
changes with each replication? CTRL-C, CTRL-V type copying doesn't work,
neither does the old grab the little black cross in the bottom right corner
and drag it option.

If it makes any difference, I am using XL 2003

TIA

Dave

 

[Dave Peterson]

Maybe you can modify this:
http://contextures.com/xlForm01.html
(from Debra Dalgleish's site)

 

[Risky Dave]

You, sir, are a gentleman! Exactly what I was after, many thanks.

I can also recommend the Contyextures site Dave's link points to for a
wealth of resouirces.

Dave