Results 1 to 6 of 6

List Box Trouble Run Time Error

Threaded View

  1. #1
    Registered User
    Join Date
    03-10-2013
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    16

    Question List Box Trouble Run Time Error

    I am trying to move string from a list box when I have them Selected and a Check box is true; when these two are true the click of the command buttion should add them to the defined sheet. Please review my code and tell me what I am not defining?
    Private Sub ADDBTN_Click()
         If ListBox1.List.Selection = True And CHBX = True Then
                 Worksheets("CH") = UserForm1.ListBox1.List.Selection
                 End If
                  
    End Sub
    New to VBA and looking for any help to complete this

    Thank you,
    Attached Files Attached Files
    Last edited by jwalma; 03-27-2013 at 10:24 PM. Reason: New Twist

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1