+ Reply to Thread
Results 1 to 8 of 8

Rows in Listbox to rows in Excel (Range)

  1. #1
    Registered User
    Join Date
    07-16-2015
    Location
    Ommelanderwijk, Netherlands
    MS-Off Ver
    2010
    Posts
    13

    Rows in Listbox to rows in Excel (Range)

    Hi,

    Searching for a way to write the rows in listbox2 into Excel
    (for example A:A)

    Can anyone help me?

    Thanks in advance

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Rows in Listbox to rows in Excel (Range)

    Littlefarmer, can you post your workbook? At least need to know if listbox2 is a form control on a sheet, or in a userform... or is it an activeX control?
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  3. #3
    Registered User
    Join Date
    07-16-2015
    Location
    Ommelanderwijk, Netherlands
    MS-Off Ver
    2010
    Posts
    13

    Re: Rows in Listbox to rows in Excel (Range)

    test.xlsm


    First, names have to be placed in listbox2 from listbox1,
    using double click or Commandbutton2.

    After this, when Commandbutton4 is clicked, data in listbox2
    has to be sorted on sheet "Gegevens" in column B.

  4. #4
    Registered User
    Join Date
    07-16-2015
    Location
    Ommelanderwijk, Netherlands
    MS-Off Ver
    2010
    Posts
    13

    Re: Rows in Listbox to rows in Excel (Range)

    Can someone help me?

  5. #5
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,908

    Re: Rows in Listbox to rows in Excel (Range)

    Please Login or Register  to view this content.

  6. #6
    Valued Forum Contributor Kamboj's Avatar
    Join Date
    09-25-2014
    Location
    India
    MS-Off Ver
    2003 - 2010
    Posts
    430

    Re: Rows in Listbox to rows in Excel (Range)

    when you press command 4 button the sort data of list2 go to the col. b
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    07-16-2015
    Location
    Ommelanderwijk, Netherlands
    MS-Off Ver
    2010
    Posts
    13

    Re: Rows in Listbox to rows in Excel (Range)

    Thank you very much

  8. #8
    Valued Forum Contributor Kamboj's Avatar
    Join Date
    09-25-2014
    Location
    India
    MS-Off Ver
    2003 - 2010
    Posts
    430

    Re: Rows in Listbox to rows in Excel (Range)

    Glad to help.

    Click *Add Reputation to say Thank and Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) If you are satisfied

    Regards

    Kamboj

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculate Average Time between Two Rows in a Range of Many Non-Consectuive Rows
    By aferoz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-13-2014, 11:51 PM
  2. Replies: 1
    Last Post: 09-24-2014, 10:30 AM
  3. [SOLVED] Multi-column Listbox - Dynamic range - over 4,000 rows of data
    By s2jrchoi in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-12-2013, 04:39 PM
  4. [SOLVED] First unhide all rows - then hide rows based on specific cell value for a range of cells
    By robbiekh in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-22-2013, 05:46 PM
  5. Replies: 4
    Last Post: 09-24-2013, 05:44 AM
  6. Fill a LISTBOX from a range, WHITOUT BLANK ROWS
    By aleebaba in forum Excel - New Users/Basics
    Replies: 11
    Last Post: 11-07-2011, 03:06 AM
  7. Find the rows in excelsheet and pop up listbox with those rows
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-09-2010, 12:11 PM

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