+ Reply to Thread
Results 1 to 11 of 11

Transfer Userform Data to Cells on Worksheet

  1. #1
    Registered User
    Join Date
    11-19-2020
    Location
    New Castle DE
    MS-Off Ver
    2013
    Posts
    17

    Question Transfer Userform Data to Cells on Worksheet

    Hello! I have been working on a spreadsheet, and teaching myself vba a bit in the process.
    I have been able to get the basics of what I was trying to accomplish, which is to track projects, and have column a change color to represent
    each stage of the project, as the proper field is completed going across the row.

    I realized that this will get to be cumbersome, and decided it would be best to use a userform for entering new projects. I have spent hours today watching youtube tutorials, reading through web sites, and just cannot seem to figure out where to start.

    I have attached the file to this post. Would anyone be kind enough to help me out? Once I learn something, I am very good at making the correlations and being able to adapt it, it just seems there are not a ton of well done tutorials on how to do this, rather more that show you an example that does not translate well into a different project.

    Any help would be greatly appreciated
    Attached Files Attached Files

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Transfer Userform Data to Cells on Worksheet

    .
    This is a sample that is fully functional. You can easily adapt the code to meet your project.

    Please Login or Register  to view this content.
    Download Sample Workbook : https://www.amazon.com/clouddrive/sh...VuDU7hFlFDiXy9

  3. #3
    Registered User
    Join Date
    11-19-2020
    Location
    New Castle DE
    MS-Off Ver
    2013
    Posts
    17

    Re: Transfer Userform Data to Cells on Worksheet

    could you please tell me what the A:A is referencing in the line below?

    Please Login or Register  to view this content.

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Transfer Userform Data to Cells on Worksheet

    .
    Please Login or Register  to view this content.
    See the attached as I had to recreate your main sheet so you can add data via the UserForm.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    11-19-2020
    Location
    New Castle DE
    MS-Off Ver
    2013
    Posts
    17

    Re: Transfer Userform Data to Cells on Worksheet

    Logit has been a tremendous help with this!

    I do have a small problem remaining. It appears that my data is being placed in Column A, when it needs to be in Column B. Looking at the code, I cannot see why? Can you take a quick peak and possibly see the problem?

    Also, it appears that my vba for the color changing of the project status is now not working. Could this be a conflict with the code? (Screenshot attached)
    Attached Images Attached Images
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    11-19-2020
    Location
    New Castle DE
    MS-Off Ver
    2013
    Posts
    17

    Re: Transfer Userform Data to Cells on Worksheet

    Thanks so much! I've got the form working, but now have 2 small issues that have popped up with data populating in column A, instead of Column B, as well my vba to change colors of column A on the change of project status is no longer working, which i believe is a result of the wrongful poplation in column A. Screenshot and file attached below. Do you have any advice on this?

  7. #7
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Transfer Userform Data to Cells on Worksheet

    .
    Notice that the code begins with Col 2 :

    Please Login or Register  to view this content.
    A = 1
    B = 2
    C = 3
    etc
    etc

  8. #8
    Registered User
    Join Date
    11-19-2020
    Location
    New Castle DE
    MS-Off Ver
    2013
    Posts
    17

    Re: Transfer Userform Data to Cells on Worksheet

    I am getting there! It stinks to be trying to learn this at 48 years old
    I have fixed that issue, but am still left with my VBA not working for the color changing Status, which is the main purpose.
    Is there anything obvious as to why it doesn't work with the user form?

  9. #9
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Transfer Userform Data to Cells on Worksheet

    .
    If you are working with the last workbook I posted, some of the coding you have within the workbook was either moved or edited in order for the UserForm to work correctly.
    You will need to re-enter the code and correct any flaws so the Color Coding and the UserForm can work without error.

  10. #10
    Registered User
    Join Date
    11-19-2020
    Location
    New Castle DE
    MS-Off Ver
    2013
    Posts
    17

    Re: Transfer Userform Data to Cells on Worksheet

    Well that's not good. I don't have the skill set to figure that out just yet, so I will go back to using it without the user form until I can get it going. Sidenote: As useful as vba is in excel, i wish there were some classes available to learn it locally. Thank you for all of your help. You have been tremendous.

  11. #11
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Transfer Userform Data to Cells on Worksheet

    .
    You mentioned you are 48 years old. I'm 70. Been learning VBA for two years. It is a hurdle at first but with perseverance everything begins to make sense. And there is
    always a learning curve. It never ends.

    Google and the Forum Boards are your friends. I found Google at first to be most helpful. And when entering a search criteria ... using key words instead of whole or partial sentences seems
    to work best.

    Example : "How do I get data from a User Form to be entered on the sheet starting in Column A on Row 13 ?"

    That can be reduced to : TextBox Data, User Form, Row X

    Stick with it. If you are like me, finding the solution is a challenge ... like a puzzle that needs to be solved. I simply MUST solve this challenge.

    Cheers.

+ 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] How to transfer data from UserForm to Worksheet
    By Frigide in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-19-2019, 03:42 AM
  2. [SOLVED] Transfer Data from Userform to Worksheet Table
    By How How in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 01-10-2017, 04:02 PM
  3. Data Transfer: Userform to Worksheet
    By smartbuyer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-24-2014, 01:15 PM
  4. [SOLVED] Transfer Userform data on 1 worksheet to different worksheet (empty row = wrong sheet)
    By HeyInKy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-26-2014, 10:08 AM
  5. [SOLVED] Userform transfer data into worksheet
    By kheytli in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-30-2013, 01:09 PM
  6. Replies: 20
    Last Post: 05-24-2012, 10:51 AM
  7. Transfer Data From Userform to Worksheet
    By ScotyB in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2012, 07:12 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