So basically I have a excel sheet (that I've attached), I recorded a macro to webquery the values into the spreadsheet.
I need help on the second part of the application now.
I need to create a userform that will allow a user to choose one of the twelve houses listed in the spreadsheet, and then to enter how many year mortgage they wish to take (e.g. 1 to 50 year mortgage) and how much of a down payment they wish to make.
Then the application needs to calculate the monthly mortgage payment on the full house price including legal fees, property taxes (monthly) and monthly mortgage insurance costs (all in the spreadsheet plus GST (5%) and less any down payment (user input).
Anybody have any idea how to do this via a userform? Any help would be appreciated!
Thanks.
Also posted here:
ozgrid.com/forum/showthread.php?t=147651&p=529009#post529009