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
    Posts
    12

    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

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





Click Here to Expand Forum to Full Width

Featured