Use fill form to place data on a specific sheet without "acitvating" the sheet...

Ok. Stay with me.

I am creating a family budget program. I have designed a fill form to enter individual receipts into a "log" sheet (tab 2 is named "log"). When the "enter" button is clicked on the fill form, the entered information is placed into the next set of blank cells on the sheet called "log". The plan is to then use the "log" sheet as a database to create sort, filter, and create a pretty report of where our money is going. Everything is working great so far, except this one issue:

When I click the "enter" button on the fill form, the view changes to the active sheet "log". The information is being transferred correctly, but I want my view to remain stagnate. i.e. , I don't want the user to see the "log" sheet that contains the data. I want the user to continue looking at the same sheet the entire time.

Let me know if my question is unclear please. I'm sure you can tell by my post that I am new to VB. But I love it. Thanks in advance for your help. Here is the code (excel 2007):

Please Login or Register  to view this content.

The usual way:

Please Login or Register  to view this content.

You no longer need this line:

Please Login or Register  to view this content.

Remove it!

There may be other changes required......................Post the full sub.

By Removing that line, the data is incorrectly transferred to sheet 3 (sheet being viewed) instead of transferring to sheet 2 (desired sheet for data entry). Thank you very much for your help.

Here is the full program...

Please Login or Register  to view this content.

I see where emptyrow is used.

Replace:

Please Login or Register  to view this content.

with:

Please Login or Register  to view this content.

Here is the spreadsheet

I tried send the file back.......