Help with Form and VBA Code

  • Hello,


    I am currently trying to create a Client form for work and followed a You tube tutorial to complete the form. However, I have tried data mapping(this help with knowing where all the information on sheet 1 should go on sheet2) before completing the ViBA code. however , when I go to enter the next set of code all of the data mapping I used previously keep erasing. The premise for the form is to input information on sheet 1 which is the form and have it save to save sheet2. I am a newbie so your help is greatly appreciated. Thanks. I have attached the workbook for review.

  • Hello and Welcome to the Forum :)


    For somebody who just started out ... All my Congratulations ...!!! :)


    At this stage, what is precisely the next issue you would like to fix ....


    Edit:

    found a tiny mistake in your macro : Prov_Load

  • Thank you for your kind words and looking over my VBA. At this time I am having an issue with saving new records. I am receiving the attach message .

  • Try this


    Code
     Sheet2.Cells(1, ProvCol).Value = Sheet2.Cells(ProvRow, ProvCol).Value

    To replace


    Code
    .Range(Sheet2.Cells(1, ProvCol).Value).Value = Sheet2.Cells(ProvRow, ProvCol).Value
  • Will take a look at your Prov_SaveNew macro ... but what are the modifications you have made ...

    and why would you need an empty loop ?


    Code
    For ProvCol = 1 To 20
    '
    Next ProvCol

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Hello, Thank you but still receiving an error. When I input the new record it save on sheet 3 instead of sheet 2. I don't know why that is happening. I am going to start over and look and see where I made my mistake. What I want to happen sound easy but it is hard with getting the VBA code to work.

  • Try this


    Code
     Sheet2.Cells(1, ProvCol).Value = Sheet2.Cells(ProvRow, ProvCol).Value

    To replace


    Code
    .Range(Sheet2.Cells(1, ProvCol).Value).Value = Sheet2.Cells(ProvRow, ProvCol).Value

    Hello,


    I tried that but still receiving an error. I am going to start over and see why I am getting these error

  • Hello again,


    Are you trying to replicate the video " How To Create An Excel Data Entry Form WITHOUT A UserForm" from Randy Austin ...?


    External Content www.youtube.com
    Content embedded from external sources will not be displayed without your consent.
    Through the activation of external content, you agree that personal data may be transferred to third party platforms. We have provided more information on this in our privacy policy.

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Hello,


    Yes, I am. I already have the data on an excel sheet and just need a better way to track what I am doing. I am rewatching his data mapping video to make sure I am doing the right thing.

  • Hopefully ... you have also downloaded his sample Excel file from his site ... ;)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!