# I'm going to be needing some Visual Basic help **URL:** \ **Category:** Miscellaneous and Personal Stuff I Must Share\ **Created:** [October 10, 2003, 6:03am UTC](https://boards.straightdope.com/t/im-going-to-be-needing-some-visual-basic-help/206628 "2003-10-10T06:03:52Z")\ **Posts on this page:** 7\ **Page:** 2
**Author:** ![Cisco](https://avatars.discourse-cdn.com/v4/letter/c/ccd318/32.png) [@Cisco](https://boards.straightdope.com/u/Cisco)\ **Post date:** [October 12, 2003, 8:49pm UTC](https://boards.straightdope.com/t/im-going-to-be-needing-some-visual-basic-help/206628/21 "2003-10-12T20:49:41Z")
Ok, the best way I can explain it is that I’m working with 3 different loan programs that each have their own guidelines. For each program we have a base interest rate and then a whole page of variables (credit score, loan-to-value ratio, documentation type…etc) that add or subtract points from the initial rate. The reason we’re making the calculator is so we can put all this info in, hit “calculate” and have our rate in a few seconds rather than adding it all up by hand. Does that make a little bit more sense? I can answer any other questions you guys have, I really appreciate the help :). P.S. As an afterthought, I’m not sure if it was clear that we want all these variables in combo boxes. We want to input a few numbers, select the variables out of the combo boxes, and hit calculate to get our rate. I can show the interface to anyone who wants to see it if that would help. ---
**Author:** ![Parallax](https://avatars.discourse-cdn.com/v4/letter/p/bbce88/32.png) [@Parallax](https://boards.straightdope.com/u/Parallax)\ **Post date:** [October 12, 2003, 11:34pm UTC](https://boards.straightdope.com/t/im-going-to-be-needing-some-visual-basic-help/206628/22 "2003-10-12T23:34:49Z")
Not to derail this project - but it sounds like this might be better suited as an Excel spreadsheet? You could set it up the formula for the cells and if a cell value changes it would recalculate the mortgage rate. As for the question at hand - I think I’m understanding now - the: FICO Score \>= 700 -.375 Rate line means that if the FICO score value is greater than or equal to 700 then subtract .375 from the final rate? I assume all of the data works like this? ---
**Author:** ![Mangetout](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/mangetout/32/19_2.png) [@Mangetout](https://boards.straightdope.com/u/Mangetout)\ **Post date:** [October 13, 2003, 12:00am UTC](https://boards.straightdope.com/t/im-going-to-be-needing-some-visual-basic-help/206628/23 "2003-10-13T00:00:34Z")
A table would really lend itself well to the storage of parameters for each mortgage plan; you can very easily link an access database into VB, but to do so for a single table might be considered wasteful - there are other data structures that hold their tables as discrete files which could just as easily be linked in(Access stores ‘the database’ as one big file, containing tables, queries, forms etc.). If the end user has Access installed though, I’d consider creating it as a pure Access application - programming the VBA form/code side of Access is closely similar to pure ‘VB proper’. ---
**Author:** ![Cisco](https://avatars.discourse-cdn.com/v4/letter/c/ccd318/32.png) [@Cisco](https://boards.straightdope.com/u/Cisco)\ **Post date:** [October 13, 2003, 3:15am UTC](https://boards.straightdope.com/t/im-going-to-be-needing-some-visual-basic-help/206628/24 "2003-10-13T03:15:33Z")
> [@](#): > > \*Originally posted by Parallax \* > \*\*As for the question at hand - I think I’m understanding now - the: > > FICO Score \>= 700 -.375 Rate > > line means that if the FICO score value is greater than or equal to 700 then subtract .375 from the final rate? I assume all of the data works like this? \*\* Correct. ---
**Author:** ![Cisco](https://avatars.discourse-cdn.com/v4/letter/c/ccd318/32.png) [@Cisco](https://boards.straightdope.com/u/Cisco)\ **Post date:** [October 13, 2003, 11:45pm UTC](https://boards.straightdope.com/t/im-going-to-be-needing-some-visual-basic-help/206628/25 "2003-10-13T23:45:24Z")
Do any of you have messenging programs we can talk on? AIM is my preference but I can log on whatever you’re using. QED - the yahoo id in your profile doesn’t work. ---
**Author:** ![Cisco](https://avatars.discourse-cdn.com/v4/letter/c/ccd318/32.png) [@Cisco](https://boards.straightdope.com/u/Cisco)\ **Post date:** [October 18, 2003, 7:55pm UTC](https://boards.straightdope.com/t/im-going-to-be-needing-some-visual-basic-help/206628/26 "2003-10-18T19:55:21Z")
Is anyone still willing or able to give me a hand with this? ---
**Author:** ![Q.E.D](https://avatars.discourse-cdn.com/v4/letter/q/51bf81/32.png) [@Q.E.D](https://boards.straightdope.com/u/Q.E.D)\ **Post date:** [October 18, 2003, 8:05pm UTC](https://boards.straightdope.com/t/im-going-to-be-needing-some-visual-basic-help/206628/27 "2003-10-18T20:05:42Z")
> [@](#): > > \*Originally posted by Cisco \* > \*\*QED - the yahoo id in your profile doesn’t work. \*\* It should. I just checked it again, and it is correct. What’s it say when you try to add me in? Also, when you do, mention the SDMB or you’ll get denied. [Previous page](https://boards.straightdope.com/t/im-going-to-be-needing-some-visual-basic-help/206628.md?page=1)