ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Option Buttons from the Forms Toolbar - Excel 2003 (https://www.excelbanter.com/excel-worksheet-functions/162025-option-buttons-forms-toolbar-excel-2003-a.html)

mickey

Option Buttons from the Forms Toolbar - Excel 2003
 
I am trying to create 2 different groups of buttons in a single worksheet.
Each group referencing a different cell. Both groups keep referencing the
same cell. I have trying changing the cell reference in the object properties
several times. No luck.

Does anyone have any idea how I can make these reference 2 different cells?

Dave Peterson

Option Buttons from the Forms Toolbar - Excel 2003
 
Since those optionbuttons are from the Forms toolbar, you can put a GroupBox
(also on the Forms toolbar) around each group. Then try changing the linked
cells.

mickey wrote:

I am trying to create 2 different groups of buttons in a single worksheet.
Each group referencing a different cell. Both groups keep referencing the
same cell. I have trying changing the cell reference in the object properties
several times. No luck.

Does anyone have any idea how I can make these reference 2 different cells?


--

Dave Peterson

mickey

Option Buttons from the Forms Toolbar - Excel 2003
 
Thanks Dave. This worked perfectly.

"Dave Peterson" wrote:

Since those optionbuttons are from the Forms toolbar, you can put a GroupBox
(also on the Forms toolbar) around each group. Then try changing the linked
cells.

mickey wrote:

I am trying to create 2 different groups of buttons in a single worksheet.
Each group referencing a different cell. Both groups keep referencing the
same cell. I have trying changing the cell reference in the object properties
several times. No luck.

Does anyone have any idea how I can make these reference 2 different cells?


--

Dave Peterson



All times are GMT +1. The time now is 11:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com