Am trying to make a little calculation program in Excel where I can calculate a gross income based on a net guaranteed income for work (based on the Dutch tax system that is)
Already have all the formulas in place and it looks like everything is working, except for one thing that annoys the hell out of me. I want it so that when all data is entered, all that needs to be done is click a button and have the gross income calculated based on the entered net income.
I have recorded the macro (Goal Seeker) and that one is working perfectly. I have been able to get this macro linked to a button in Excel 2000 (which we have at work), but I cannot seem to get it linked to a button in Excel XP (OfficeXP pro).
I have spent many many hours trying to get this working, read through all the help files in Excel, but since the sleep deprivation is getting to me and I do have to study for finals next week, I am hoping someone here knows how to accomplish this and I can go to bed before 4 am this time
So, in brief, how do I get this macro to work when clicking on the button in Excel XP.
Many thanks in advance!