+ Reply to Thread
Results 1 to 3 of 3

Transfer data from Userform1.listbox1 to userform2.listbox2

  1. #1
    Registered User
    Join Date
    07-04-2013
    Location
    Clermont-Ferrand
    MS-Off Ver
    Excel 2010
    Posts
    2

    Transfer data from Userform1.listbox1 to userform2.listbox2

    Hello Masters of Vba programming,

    i have some troubles with my Vba code. (it disagree with me too much times this week )
    My problem is (as the title explain) to transfer data from a first listbox in a first userform to a second listbox in a second userform.
    The listboxes have 2 columns.
    I think my main problem is that i don't know how to handle the private subs of userform...


    Thank you in advance
    PS : i apologize about my english if you don't understand anything, please tell me !

  2. #2
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: Transfer data from Userform1.listbox1 to userform2.listbox2

    Check this example file: Listbox.xlsm

    Userform1 Listbox1 is filled with test data, select a record and click "To UF 2" to transfer it to the listbox of userform2
    Please use [CODE]-TAGS
    When your problem is solved mark the thread SOLVED
    If an answer has helped you please click to give reputation
    Read the FORUM RULES

  3. #3
    Registered User
    Join Date
    07-04-2013
    Location
    Clermont-Ferrand
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Transfer data from Userform1.listbox1 to userform2.listbox2

    this is great ! thank you tehneXus !

    your code is very clean and understandable !
    I think i can adapt it easily !

    Really thanks !

+ Reply to Thread

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