Read the value of an excel radio button?

May 10, 2010 at 9:27 PM
Edited May 10, 2010 at 9:28 PM

I have a worksheet that has a couple radio buttons and checkboxes inside an excel workbook. They were added using the Forms toolbar (View -> Toolbars -> Forms).

It looks like these controls themselves are NOT tied to a particular cell, because when I get the HSSFCell object the value of the radio button or checkbox is not in the cell. Is it possible to read the value? (Ex: checked/not checked or true/false)

As a workaround, I'm thinking a macro could populate a different cell with the value? Any advice is appreciated.