Hi,
I'm new to Macros/VBA so I'm hoping I can get some specific instructions but if not, the solution will be enough and I'll figure the rest out. I'm using Excel 2010, I'll get to the point!
I have developed a calculator (attached) to make life easier for my colleagues. It works perfectly fine. But one thing keeps bugging me which I want help with before presenting it to everyone.
In Cell C3 - You have the option to choose "Daily" or "Weekly" (Drop Down). This selection effects your selection for Cell C6.
If you choose Daily in Cell C3 then your options for Cell C6 are restricted to select/enter an amount between £0.00 and £6.00.
If you choose Weekly in Cell C3 then your options for Cell C6 are restricted to select/enter either £0.00 or £12.00.
This works perfect.
However, if I select "Weekly" and then select "£12.00", all my results are perfect which is exactly what I want BUT if I then go back up to C3 and change "Weekly" to "Daily", the £12.00 in C6 remains (though the data validation for "Daily" is restricted to £0.00-£6.00) and all the results are consequently wrong until C6 is changed.
The obvious thing is to delete the £12.00 from Cell C6 or introduce a "clear" button BUT I don't want my colleagues to do this as it leaves the possibility of error and since we are dealing with money, I can't have it.
So what I would love and what would complete this calculator and deem it ready is if every time Cell C3 is selected (i.e. from the drop down list you choose Weekly or Daily) it as a result resets Cell C6 to £0.00. Does that make sense? I mean I've been working on this for a week so all I'm saying makes sense in my head but when I'm typing this it may not come cross clear.
If you need me to clarify anything please ask and I would appreciate any help. I have attached my work so far so you can see it and it'll make it easier for you but I don't think I am ever going to solve this without some expert help. Thanks.
Calculator 23-06-14.xlsx
Bookmarks