+ Reply to Thread
Results 1 to 6 of 6

Data Entry Form Inserting New Row Outside of Table

  1. #1
    Registered User
    Join Date
    04-23-2019
    Location
    Pittsburgh, PA
    MS-Off Ver
    MS Office 365
    Posts
    7

    Question Data Entry Form Inserting New Row Outside of Table

    Hello!

    I've created a Data Entry form that I want to insert a new row at the top of of a table.

    The code I'm using was copied from another site and, while it is indeed adding a new row, it's doing so in the cells below the table instead of inside which is negating the table formatting altogether.

    I'm hoping you can help me change this code to operate as such. I'll attach screenshots to hopefully better illustrate what I'm looking to do.

    Thanks!

    Please Login or Register  to view this content.
    Capture.PNG
    Last edited by Niccii; 04-24-2019 at 03:13 PM. Reason: Added Images

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,230

    Re: Data Entry Form Inserting New Row Outside of Table

    Hi Niccii

    I want to insert a new row at the top of of a table.
    You have not uploaded a sample file but this will give you an idea...
    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Registered User
    Join Date
    04-23-2019
    Location
    Pittsburgh, PA
    MS-Off Ver
    MS Office 365
    Posts
    7

    Re: Data Entry Form Inserting New Row Outside of Table

    Sintek, how silly of me, I hadn't thought to connect the workbook!

    I've attached it now if you'd like to take a look at it.
    (At least I tried to, it won't let me post it until I've made a few posts)

    I did attempt to add your code, but I'm not entirely sure how to make it fit in with the cmdAdd_Click code.

    I tend to overreach for my skill set, but I guess that's how we learn, right?

    Please Login or Register  to view this content.

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,230

    Re: Data Entry Form Inserting New Row Outside of Table

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    04-23-2019
    Location
    Pittsburgh, PA
    MS-Off Ver
    MS Office 365
    Posts
    7

    Re: Data Entry Form Inserting New Row Outside of Table

    Hmm, it's still not adding at the top of the checklist, so the data set is listed backwards to what I'd prefer... it may just work for the time being. I'm not sure how much I want to fight it.

  6. #6
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,230

    Re: Data Entry Form Inserting New Row Outside of Table

    What do you mean...
    Hmm, it's still not adding at the top of the checklist
    What checklist...
    Explain in detail where you want the data to be added...Perhaps you should upload a before and after sheet with your expected results depicted...
    The code provided will add your new data to row 3 of your Table...every time you press the button
    Last edited by sintek; 04-26-2019 at 02:42 PM.

+ 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] Data entry form to populate certain table dependent on validation list
    By nmorrow in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-10-2017, 05:22 AM
  2. [SOLVED] Help with custom data entry form with dropdown lists populated by table columns...
    By gaz1man in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-12-2014, 01:28 PM
  3. Inserting a table in an excel form
    By andrete in forum Excel General
    Replies: 1
    Last Post: 02-08-2014, 11:30 AM
  4. [SOLVED] HELP: Inserting a drop down box into a Data Entry Form
    By mwinter in forum Excel General
    Replies: 12
    Last Post: 12-18-2013, 03:32 PM
  5. Replies: 2
    Last Post: 06-07-2013, 09:08 AM
  6. Date capture in Entry Form to Data Table
    By JIBG in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-02-2007, 09:14 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