+ Reply to Thread
Results 1 to 3 of 3

vba, transfer data between userforms

  1. #1
    Registered User
    Join Date
    05-05-2020
    Location
    Germany
    MS-Off Ver
    2013
    Posts
    82

    vba, transfer data between userforms

    Hello

    this code will transfer the data from a list box to another userform by double clicking on it.
    now instead of double clicking the row, I want to put a button, so that the user selects the row by clicking on it and then clicks on the button, which will transfer the data to the userform1.

    Can someone help me to change the code for the button?
    What should I add so that vba knows which row is selected?

    This is the code I'm using:
    Please Login or Register  to view this content.

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    5,949

    Re: vba, transfer data between userforms

    Your code already takes care of that, since it transfers the selected row on double-click, so all you need to do is move it to a button click event.
    Rory
    I drink, and I know things

  3. #3
    Registered User
    Join Date
    05-05-2020
    Location
    Germany
    MS-Off Ver
    2013
    Posts
    82

    Re: vba, transfer data between userforms

    Quote Originally Posted by rorya View Post
    Your code already takes care of that, since it transfers the selected row on double-click, so all you need to do is move it to a button click event.
    (^_^ ; ) Thanks

+ 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. Transfer & confirm data transfer between workbooks
    By fenfool in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-02-2015, 01:10 PM
  2. Editing data with userforms
    By EDUcoordGR in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-02-2009, 10:43 PM
  3. Moving Data between two userforms
    By sportsranker in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-09-2009, 06:31 PM
  4. grouping data via userforms
    By jpruffle in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-08-2009, 10:47 AM
  5. Show two UserForms and transfer data
    By jagman in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-27-2008, 01:00 AM
  6. Data Validation in Userforms
    By alexa in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-29-2006, 08:12 AM
  7. [SOLVED] Data Validation on UserForms
    By SailFL in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-19-2005, 05:05 AM

Tags for this Thread

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