Your own personal Loan Application!

Who could have known that you were running an EasyCashLoans business on the side while studying at TAFE?? Today's first activity is designed to re-cap most of what we've been learning so far with our Excel VBA, such as:

• Using forms to get user input onto the worksheet
• Checking the users information before entering it on the worksheet (input validation)
• Using VBA to find the next empty row to enter our information.

I'm keen for people to have enough time today to catch-up on some of the previous exercises (quite a few people have been away!), so you might want to chat with me first before starting this new one!

The scenario:
After a few successful sales on E-bay last year, you've been able to loan small cash advances to friends and family for the past 6 months, in exchange for some item of value that you can pawn if the loan isn't repayed. (Nice friend you are ;-) )

The task:
We'll be working together to develop an application to help you track your loans as your business grows. I've already done all the mundane stuff for you (creating a few forms), you'll find instructions for the rest in the actual worksheet. We'll be building on our previous learning this week by adding proper input validation to our forms, and creating a search function for your loan application, allowing you to find your customers as your business expands!

If you're working on this before class (I sent out the file previously via email) and you get stuck, try having a browse through the tutorial Create User Forms in Microsoft Excel or Mark Thorpe's Excel VBA Beginner Tutorials and see if you can get some help online!

And if you find this all too easy, have a go at adding a form to help you calculate loan repayments (using the VBA pmt() function).