i have a excelsheet exported from datatable
option button is displayed in the sheet from the code as
ActiveSheet.CheckBoxes.Add a, b c, d
the sheet has 5 columns of data
say
A2 B2 C2 D2 E2
each column has a option button
in
A1 B1 C1 D1 E1
when the user clicks one of the option button say C1 & when the sheet is imported back in a datatable i need to import only the content of column C
how can the program get the indication aboubt teh column being checked