Results 1 to 9 of 9

Update Listbox

Threaded View

Sniper Update Listbox 09-09-2009, 04:08 AM
royUK Re: Update Listbox 09-09-2009, 05:02 AM
Sniper Re: Update Listbox 09-09-2009, 05:14 AM
royUK Re: Update Listbox 09-09-2009, 07:47 AM
Sniper Re: Update Listbox 09-10-2009, 04:33 AM
royUK Re: Update Listbox 09-10-2009, 04:44 AM
Sniper Re: Update Listbox 09-10-2009, 04:50 AM
Sniper Re: Update Listbox 09-10-2009, 05:18 AM
Sniper Re: Update Listbox 09-10-2009, 05:42 AM
  1. #1
    Forum Contributor
    Join Date
    08-27-2009
    Location
    South Africa
    MS-Off Ver
    Office 2010
    Posts
    217

    Question Update Listbox

    I have a combo box, when I make a selection in the combobox it filters the selection in the listbox but I want it to list Column B & C data - it only lists column B data. I did make the column count 2

    Private Sub ComboBox8_Change()
    Dim rng As Range
    UserForm2.ListBox1.Clear
    
    For Each rng In Range("B3:C3", Range("B3:C3").End(xlDown))
        If rng.Offset(, -1) = Me.ComboBox8.Value Then UserForm2.ListBox1.AddItem rng
    Next rng
    
    End Sub
    Last edited by Sniper; 09-10-2009 at 05:43 AM.

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