Hi,
I am new to the forum and new to VBscript programming. I recently was given the task to program a calculator with VBscript that would be able to accurate price out the most cost effective way to buy laboratory rats. So, I pretty much had to teach myself VBscript. I have a basic case structure macro, but not much else. This is what I came up with (see attachment).
There are a few things I want to fix and do with the spreadsheet:
1. I would like to make a code for the 4 yes/no questions that can override the input in cell B5. I would also like to make it spit out a specific value in B12 when answered with YES in one of those drop down menus. Hopefully there is no overlap because these are all separate prices
2. Whenever I have a set weight in Male or Female, the price value comes up right, but if I keep that same weight value and change to the opposite gender, it doesn't change. I'd like to fix this.
3. Cell B6: I want this to be reflected in the total cost because it will be something like how many rats we order per week.
4. Cell B14: I want the utilization rate to reflect in the total cost by affecting the per diem cost (i.e., if I use one rat a week and the cost would decrease based on how many rats I used).
5. Cell B15: I would like to have this cell have an input of days and multiply that input by a specified dollar amount to give the per diem total. (is there a VBscript code to do this?)
6. I would like to create a separate table within this spreadsheet that can extrapolate 1 month, 2 month, 4 month, 6 month, and 12 month costs.
I am not necessarily looking for someone to do this for me, just help with the coding and macros I'd implement. I hope to learn a fairly good amount so that I can keep these macros for later or build upon them myself.
I may have not been the clearest in this post, but if you have any questions please ask --- this task has been driving me nuts! Also, I have attached the PDF of costs that I am referencing.
Thanks!
Bookmarks