how to loop through option buttons
 

first, let me say i am working with 2003 excel.
so i have this column of data. i want to have a column of option buttons
right next to the column of data so that you can easily choose which piece of
data to work with the various other macros i have written. the problem is, i
need support for ALOT of these option buttons... say 300? I dont want to
write 300 _change() subroutines. is there a way to loop through all the
option buttons and find the one thats enabled? I would also want to grab the
cell immediately to the left of the option button.
the excel help files dont have much info on option/radio buttons :)

how to loop through option buttons
 

I would assign a linked cell to each of the optionbuttons and then loop through
those linked cells.

Are you sure you're using optionbuttons from the control toolbox toolbar (the
circular radio buttons)? If yes, then does this mean that you assigned a
groupname to each group of these optionbuttons?

Or is it possible you meant checkboxes (a single yes/no choice)?

And are you sure you used the controls from the control toolbox toolbar.

=======

If you had multiple options to choose from and wanted to use optionbuttons from
the Forms toolbar, you could look at Debra Dalgleish's site:
http://contextures.com/xlForm01.html

Blahdee wrote:

first, let me say i am working with 2003 excel.
so i have this column of data. i want to have a column of option buttons
right next to the column of data so that you can easily choose which piece of
data to work with the various other macros i have written. the problem is, i
need support for ALOT of these option buttons... say 300? I dont want to
write 300 _change() subroutines. is there a way to loop through all the
option buttons and find the one thats enabled? I would also want to grab the
cell immediately to the left of the option button.
the excel help files dont have much info on option/radio buttons :)

--

Dave Peterson