Two sets of option boxes? two separate reference cells?
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? |
Two sets of option boxes? two separate reference cells?
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 |
Two sets of option boxes? two separate reference cells?
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 |
All times are GMT +1. The time now is 12:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com