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..


Reply With Quote
Bookmarks