+ Reply to Thread
Results 1 to 6 of 6

Data Entry Form VBA Code

  1. #1
    Registered User
    Join Date
    09-18-2019
    Location
    manila
    MS-Off Ver
    2013
    Posts
    3

    Data Entry Form VBA Code

    Hi, i'm new to vba and just watching youtube videos for tutorials. I was able to follow some but my save function is not working and the information is not being saved on the "Data" sheet. i copied the formula as shown in the tutorial but no luck. any one can help? here's the vba code i have.

    thanks!
    __________________________________________________________________
    Please Login or Register  to view this content.
    Last edited by drewtom; 09-19-2019 at 10:59 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,445

    Re: Data Entry Form VBA Code

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    I did it for you this time. Please read forum rules. Thanks

  3. #3
    Registered User
    Join Date
    09-18-2019
    Location
    manila
    MS-Off Ver
    2013
    Posts
    3

    Re: Data Entry Form VBA Code

    thank you for your help! sincerely appreciated.

  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
    7,008

    Re: Data Entry Form VBA Code

    .
    Here is a basic database macro to review :

    Please Login or Register  to view this content.

    In your code, what does this line do ?

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    09-18-2019
    Location
    manila
    MS-Off Ver
    2013
    Posts
    3

    Talking Re: Data Entry Form VBA Code

    Thank you Logit! i'll test your code once i can. i believe that range is for the sequencing of the rows, ensuring the next data added will fall on the next row. i may be wrong though, just how i understand it. appreciate your time!

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

    Re: Data Entry Form VBA Code

    Glad to help.

+ 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. VBA code on form to duplicate entry depending on an entry on a field
    By jancliff in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-20-2019, 05:27 PM
  2. implementing a bar-code scanner into excel entry form
    By jr102893 in forum Excel General
    Replies: 1
    Last Post: 03-12-2015, 10:26 AM
  3. Replies: 3
    Last Post: 09-24-2013, 11:01 AM
  4. Replies: 2
    Last Post: 06-07-2013, 09:08 AM
  5. Replies: 1
    Last Post: 11-13-2012, 02:06 PM
  6. VBA code - simultaneous entry on different worksheet based on DATE ENTERED to form
    By sgtbash999 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-27-2012, 04:02 PM
  7. Data Entry Form (similar to default Excel Data>Form)
    By tonydm in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-11-2005, 02:59 PM

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