Finding this forum is like receiving a great gift. I need to write a macro that will first convert these numbers to USDollars. Since the currency rate changes daily, I need to create a command button "enter the rate". Then the viewer need the option to select "Convert to USD" or "Convert to CAN". The file is attached. Thanks for any and all help! Ener.
In which tab do you want the calculations to be done? There are several in your file.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
If you do this via VBA it will override your formulas, you would be better off with a named value for the conversion rate that you can set and include this in the formula
I will need to run the calculation on each tab sheet.
Kyle, I'm a beginner and I don't know how to create a name value. Could you tell me the steps please?
Arlette -- I will need to run the calcuation on each tab.
Sure, to make it a little dynamic, give a cell a named range where you put the conversion rate.
Then include this in your formula, for example if it was "XchangeRate", something like:
=A1*XChangeRate
You can then change the value in XChangeRate and it will change all your values
I will give it a try. Thank you
Kyle, I'm sorry but I'm not getting it. Could you perhaps take one of the sheets (DLL) and show me the steps please?
Sure, but you have already done this in some of your formulas e.g:
=(H35*bQtr1+I35*bQtr2+J35*bQtr3+K35*bQtr4)/bTotYear
I've updated the first couple of lines in DLL. Change the value in the existing exchange rate tab to see the effect.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks