"Add New Client" Button Code Adjustment For Placement of New Row

Good Morning Everyone,

I've been using this piece of VBA for a "Add New Client" button (which works great):

Please Login or Register  to view this content.

While this is great... whenever I use the button the new line in the table is scrolled all the way to the top hiding the other cells. Is there some code that I can add that will adjust the new line to about the middle of the page and have the subsequent lines above it visible? Thank you to everyone for taking the time to help me with this issue.