allison
03-06-2008, 11:28 AM
I'm trying to redesign a spreadsheet that someone else created and have a few questions.
It was designed with a row of checkboxes (using the forms toolbar). The checkboxes are associated with a cell that contains a value. More than one checkbox can be marked, which is what I'm trying to eliminate.
I've been reading about option buttons from the control toolbar. Using those should get the desired result.
Before I go much further into redesigning, I want to make sure that I understand what is needed. There are 10 rows of the checkboxes, with each checkbox being associated with a different value cell.
So, I think that I need to replace each row of checkboxes with a row of option buttons. I need to group the appropriate option buttons together so that only one per group can be selected.
To get a value associated with the row, I need to write some VBA with the click event that says if the value is true, it equals XXXX.
Does that sound correct? Am I missing something?
It was designed with a row of checkboxes (using the forms toolbar). The checkboxes are associated with a cell that contains a value. More than one checkbox can be marked, which is what I'm trying to eliminate.
I've been reading about option buttons from the control toolbar. Using those should get the desired result.
Before I go much further into redesigning, I want to make sure that I understand what is needed. There are 10 rows of the checkboxes, with each checkbox being associated with a different value cell.
So, I think that I need to replace each row of checkboxes with a row of option buttons. I need to group the appropriate option buttons together so that only one per group can be selected.
To get a value associated with the row, I need to write some VBA with the click event that says if the value is true, it equals XXXX.
Does that sound correct? Am I missing something?