Hey there,
I'm trying to create a macro for a user form so when the user fills in customer information and clicks submit, it will add a customer name and time stamp to a "customer list" table.
There will eventually be more than the customer name and time, once I get the rest of the code working properly.
It is also set to add a row to the table before adding the customer, so I never run out of rows. Not sure if that has anything to do with my issue.
Every time I run it, it adds the customer to the bottom row (the new row that it added) and still leaves empty rows above it.
I suppose it doesn't have to add a row if there is already an open row available, but the main issue is the customer should always be added to the first empty row, not the very last row.
I prefer to not upload the entire spreadsheet because there is some confidential info on it, but here is what I can share...
I attached a screenshot to that portion of the sheet. The code should've inserted Customer 2 into row 17 as it is the first empty row, but instead, it inserted them into row 20, the last empty row.
Here is the code I have right now for when the user clicks submit on the user form:
I appreciate any info you can share!Please Login or Register to view this content.
Bookmarks