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 :)