importing excel sheet with a specific column

See more:

VB

MS-Excel

web

722 Points

1770 Posts
importing excel sheet with a specific column

1 hour, 7 minutes ago|LINK

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