I am using option boxes to change a cell that calls up a set of vlookup
results.

I want a separate set of option boxes on the same sheet to point to aother
cell to call up another set of vlookup's, however when i put in the new
option boxes they all point to the same cell reference of the first set of
option boxes above.

How do you get two separate sets of option boxes which point there result to
separate reference cells?

Can anyone help?

If you use optionbuttons from the Forms toolbar, put a groupbox (also on that
same toolbar) around the optionbuttons.

And then rightclick on an optionbutton on that group, choose Format
Control|control tab. Then assign the linked cell.

If you use optionbuttons from the control toolbox toolbar, rightclick on each
of the members of the group, choose properties, and give that group a unique
groupname.

You can assign the Linkedcell on that properties window.

Roger on Excel wrote:

I am using option boxes to change a cell that calls up a set of vlookup
results.

I want a separate set of option boxes on the same sheet to point to aother
cell to call up another set of vlookup's, however when i put in the new
option boxes they all point to the same cell reference of the first set of
option boxes above.

How do you get two separate sets of option boxes which point there result to
separate reference cells?

Can anyone help?

--

Dave Peterson

Hi Dave,

Thanks - that works perfectly for me.

Best regards,

Roger



"Dave Peterson" wrote:

If you use optionbuttons from the Forms toolbar, put a groupbox (also on that
same toolbar) around the optionbuttons.

And then rightclick on an optionbutton on that group, choose Format
Control|control tab. Then assign the linked cell.

If you use optionbuttons from the control toolbox toolbar, rightclick on each
of the members of the group, choose properties, and give that group a unique
groupname.

You can assign the Linkedcell on that properties window.

Roger on Excel wrote:

I am using option boxes to change a cell that calls up a set of vlookup
results.

I want a separate set of option boxes on the same sheet to point to aother
cell to call up another set of vlookup's, however when i put in the new
option boxes they all point to the same cell reference of the first set of
option boxes above.

How do you get two separate sets of option boxes which point there result to
separate reference cells?

Can anyone help?

--

Dave Peterson