Results 1 to 3 of 3

Multi Select ListBox, 4 columns, use NamedRange, Columns to use in list Nonconsecutive

Threaded View

CRIMEDOG Multi Select ListBox, 4... 04-29-2013, 10:26 AM
MickG Re: Multi Select ListBox, 4... 04-29-2013, 10:49 AM
CRIMEDOG Re: Multi Select ListBox, 4... 04-29-2013, 11:01 AM
  1. #1
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    670

    Multi Select ListBox, 4 columns, use NamedRange, Columns to use in list Nonconsecutive

    I have Named Range: "List" - Lets say it has 10 Columns
    On my user for, I want a Multi Select List that has 4 columns.
    For the columns on the list, I would like Columns 2,5,8,7 from the Named Range

    Private Sub UserForm_Initialize()
       Dim Rge As Range
       ListBox1.List = Range("List").Value
       Set Rge = Range("List")
       
       With Me.ListBox1
        Me.ListBox1.ColumnWidths = "15;30;60;15"
        
        ListBox1(, 1).Value = Rge(, 1).Value
        ListBox1(, 4) = Rge(, 1).Value
        ListBox1(, 7) = Rge(, 1).Value
        ListBox1(, 6) = Rge(, 3).Value
    End With
    End Sub
    Last edited by CRIMEDOG; 04-29-2013 at 11:00 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