does anyone knows how to assign checkboxes a value from excel file using vb.net. it's easy to put something in the cell but i am having a hard time assigning values checkboxes in excel. i have here a sample code
Private Sub PopulateKYCIndividual()
Dim Account As New clskycIndividual
.AccountID = var_accountid
wb = xl.Workbooks.Open(GetFullpath("KYCInvidual Checklist"))
ws = wb.Worksheets(1)
ws.Range("LName").Value = .ClientName
my problem is how to assign checkboxes a value in excel file. does anyone knows how? thanks in advance..