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):
Bookmarks