Results 1 to 13 of 13

Transpose Vertical List from Listbox

Threaded View

CobraLAD Transpose Vertical List from... 06-29-2009, 03:39 AM
romperstomper Re: Transpose Vertical List... 06-29-2009, 04:17 AM
CobraLAD Re: Transpose Vertical List... 06-29-2009, 04:24 AM
romperstomper Re: Transpose Vertical List... 06-29-2009, 04:30 AM
CobraLAD Re: Transpose Vertical List... 06-29-2009, 04:47 AM
  1. #1
    Forum Contributor CobraLAD's Avatar
    Join Date
    07-23-2007
    Location
    Boksburg, South Africa
    MS-Off Ver
    Office 2024
    Posts
    347

    Transpose Vertical List from Listbox

    I am traying to make a horizontal list on sheet2 from a listbox on a userform, something is missing, please help

    Dim lItem As Long
    For lItem = 0 To ListBox2.ListCount - 1
    Sheet2.Range("A1048576").End(xlUp).Offset(0, 1).Value = WorksheetFunction.Transpose(ListBox2.List(lItem))
    Next
    Last edited by CobraLAD; 06-29-2009 at 07:16 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