+ Reply to Thread
Results 1 to 5 of 5

Userform will not add new entry

  1. #1
    Registered User
    Join Date
    12-04-2013
    Location
    los angeles
    MS-Off Ver
    Excel 2016
    Posts
    6

    Unhappy Userform will not add new entry

    Hi

    I attempted to search the thread regarding my questions, but I still need help.

    I have an UserForm and the Userform is working to a degree. I can add data from the Userform to the spreadsheet. However the Userform, keeps overriding the last entry vs. adding a new entry.

    To assist with this process, I created a Counter formula, and then added it to the VBA coding.

    Page counter formula is: =COUNTA(Client!C7:C100)-1 (However, instead of counting the cells with data, it counts the blank cells, so new entry is at page 101 vs. 12)

    VBA code is below:

    Please Login or Register  to view this content.
    Pls help and Thanks
    Last edited by jeffreybrown; 03-19-2018 at 08:26 PM. Reason: Please use code tags when posting code!

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Userform will not add new entry

    Any chance you could upload a sample workbook?

    Click on GO ADVANCED, scroll down and click Manage Attachments.
    If posting code please use code tags, see here.

  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Userform will not add new entry

    Please Login or Register  to view this content.


    Why do you have: =COUNTA(Client!C7:C100)-1
    but also:Sheets("Client Info")? Is that one sheet or two different sheets?
    Ben Van Johnson

  4. #4
    Registered User
    Join Date
    12-04-2013
    Location
    los angeles
    MS-Off Ver
    Excel 2016
    Posts
    6

    Re: Userform will not add new entry

    Hi

    I think I figured it out. It may have been a syntax error. Thanks for replying. If I have any more trouble, I will post the workbook.

    Thanks again

  5. #5
    Registered User
    Join Date
    12-04-2013
    Location
    los angeles
    MS-Off Ver
    Excel 2016
    Posts
    6

    Re: Userform will not add new entry

    Hi

    Client Info is one sheet.

    I have several sheets, so I thought I needed to identify the sheet.

    I think that I got it working now.

    Thanks for responding, I appreciate it, as I may need more help down the road.

+ 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] vba excel - test userform entry greater than last entry
    By terriertrip in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-30-2017, 07:54 PM
  2. [SOLVED] Userform for data entry
    By bqheng in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-05-2016, 09:35 PM
  3. Userform adds entry new entry instead of updating existing
    By rayexcel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-21-2014, 04:27 AM
  4. Replies: 0
    Last Post: 02-04-2014, 12:36 AM
  5. [SOLVED] After userform entry require tab entry
    By Tiger20 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-12-2013, 12:24 AM
  6. Replies: 2
    Last Post: 07-09-2012, 02:05 AM
  7. New Entry UserForm
    By zplugger in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-15-2009, 03:40 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