+ Reply to Thread
Results 1 to 2 of 2

Transfer data from cells to userform

  1. #1
    Registered User
    Join Date
    09-29-2015
    Location
    Papua,Indonesia
    MS-Off Ver
    14
    Posts
    5

    Transfer data from cells to userform

    Hi all,

    I have an excel file consist of 3 columns: PO, ITEM, SN. On the userform, user will have to enter the PO and then the data according to that PO, in this case ITEM and SN will appear on the listbox on that userform. Is there any way to do that?
    Here is the file.
    Attached Files Attached Files
    Last edited by Leviosa; 10-30-2015 at 03:07 AM.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Transfer data to userform

    Index/Match (let say "m") Me.Textbox1.value and return that to other textbox.

    Please Login or Register  to view this content.

+ 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. [SOLVED] Transfer data to and from userform
    By JumpyJim in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-11-2015, 03:21 PM
  2. combining chart userform and data transfer userform into 1 userform
    By H_Kennedy in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-04-2014, 07:11 AM
  3. combining chart userform and data transfer userform into 1 userform
    By H_Kennedy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-03-2014, 12:28 PM
  4. [SOLVED] Userform to transfer data to another userform
    By Oeysbrei in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-19-2012, 04:46 PM
  5. Transfer Data in Userform
    By vin1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-14-2012, 09:57 AM
  6. Transfer Userform Data to next empty Row
    By Mrs. Robinson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-28-2010, 04:24 PM
  7. Transfer data between Userform.
    By D_Rennie in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-30-2009, 11:49 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