+ Reply to Thread
Results 1 to 5 of 5

userform data information transfer

  1. #1
    Registered User
    Join Date
    04-10-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    8

    userform data information transfer

    hello

    I have three sheets within a Workbook - Sheet A, Sheet B and Sheet C

    In Sheet B, i have a userform in which the user inputs the data and Sheet B will update according to the user input

    In Sheet C, I have a macro that will compare sheet A and sheet B and place all the lines that do not match.

    The place where I am stuck is that I want to use the data that the user inputs in sheet B in sheet C after I have compared Sheet A and B

    Is there way to do this?

    Please let me know if I did not explain this properly

    Thanks
    Avni

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: userform data information transfer

    Any more info? Did you code the forms or use the data entry ones?
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Registered User
    Join Date
    04-10-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: userform data information transfer

    i created the userform

    this is the code for the userform on Sheet B

    Please Login or Register  to view this content.
    And this is the code
    Please Login or Register  to view this content.
    I want to then add the input from the userform in sheet B into sheet C after I autofit the columns

    I am not sure how to do that because i need to update sheet B, then compare it to A and and it auto populates sheet c and then I wanteto update sheet C with the user input from sheet B

  4. #4
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: userform data information transfer

    It looks like you already know how Sheet3.range("a1").value or sheet3.cells(1,1).value

  5. #5
    Registered User
    Join Date
    04-10-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: userform data information transfer

    yes but I am unsure on how to transfer the list of yellow clients in sheet b that I obtained from the userform and use it in sheet 3 after I have compared everything. How do I call on that variable again without having to have the user input all the data again after i compared the data

+ 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. 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
  2. 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
  3. Replies: 0
    Last Post: 04-18-2013, 10:59 AM
  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. Replies: 8
    Last Post: 05-01-2009, 12:38 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