hi everyone,
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
Code:
Private Sub PopulateKYCIndividual()
Dim Account As New clskycIndividual
With Account
.AccountID = var_accountid
.Retrieve(var_accountid)
wb = xl.Workbooks.Open(GetFullpath("KYCInvidual Checklist"))
ws = wb.Worksheets(1)
'ACCOUNT NAME
ws.Range("LName").Value = .ClientName
End With
End Sub
my problem is how to assign checkboxes a value in excel file. does anyone knows how? thanks in advance..