CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 1 of 1
  1. #1
    Join Date
    Apr 2007

    assign checkboxes a value from excel using vb.net 2005

    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

        Private Sub PopulateKYCIndividual()
            Dim Account As New clskycIndividual
            With Account
                .AccountID = 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..
    Last edited by Shuja Ali; May 30th, 2007 at 02:28 AM. Reason: Corrected the code tags.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Windows Mobile Development Center

Click Here to Expand Forum to Full Width

On-Demand Webinars (sponsored)

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.