Results 1 to 7 of 7

Multi Selection Listbox

Threaded View

protocol Multi Selection Listbox 08-16-2011, 08:08 AM
Bob Phillips Re: Multi Selection Listbox 08-16-2011, 08:44 AM
protocol Re: Multi Selection Listbox 08-17-2011, 02:24 AM
royUK Re: Multi Selection Listbox 08-17-2011, 02:29 AM
protocol Re: Multi Selection Listbox 08-17-2011, 02:32 AM
snb Re: Multi Selection Listbox 08-16-2011, 09:40 AM
protocol Re: Multi Selection Listbox 08-18-2011, 03:14 AM
  1. #7
    Registered User
    Join Date
    08-12-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Multi Selection Listbox

    @Snb
    This code is giving some error, its saying Syntax error
    This is the code :

    Dim j As Long
     For j = 0 To Sheet1.ListBox1.ListCount - 1
        If Sheet3.lstSpecialization.Selected(j) Then
            c01 = c01 & "|" Sheet3.lstSpecialization.List (j)
      Next
      If c01 <> "" Then
        sn = Split(Mid(c01, 2), "|")
        Sheet2.Cells(rows.Count, 1).End(xlUp).Offset(1).Resize(UBound(sn) + 1) = Application.Transpose(sn)
      End If
    Last edited by protocol; 08-18-2011 at 03:39 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