Previous Topic Next Topic

Different currencies

Solved/Closed
DG83 Posts 38 Registration date Monday January 2, 2012 Status Member Last seen April 21, 2018 - Mar 11, 2013 at 10:32 AM
DG83 Posts 38 Registration date Monday January 2, 2012 Status Member Last seen April 21, 2018 - Mar 30, 2013 at 02:08 PM
Hello,

could you please advise what could be the best way to show in the same table different currencies. Lets say there would be a button which would case the cells to convert to different currencies. For example: A1 cell is 5 USD, but after hitting a button it would show 3 GBP.

Thanks a lot


1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Mar 11, 2013 at 12:37 PM
Hi DG83,

Since you basicly aswered your own question, I was wondering with what you need help with.

Best regards,
Trowa
0
Dg83
Mar 11, 2013 at 12:50 PM
How would you do it technically?
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 12, 2013 at 11:27 AM
How many currency you are talking about. Plus there is alway converison rate that come into picture.
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Mar 12, 2013 at 11:40 AM
Hi DG83,

Well you need to know two things: Create button and do some math in VBA.

I just explained how to create a button. Check out my comment on 11 march in this link:
https://ccm.net/forum/affich-691007-how-to-do-an-automation-for-copy-paste-added-new-row-macro#p692746

And here is the math example: 
Range("A1").Value = Range("A1").Value * 3 / 5
Range("B1").Value = "GBP"


Combine the two to change currency with the click of a button.

If you need more assistance then it may be helpfull to post your workbook (www.speedyshare.com).

Best regards,
Trowa
0
Dg83
Mar 12, 2013 at 01:14 PM
Thanks a lot Trowa. To keep it the simplest: let's say tat cells A1:B10 contain single numbers. I don't have the X change rate. I would create a button and after hitting it it would replace the numbers in the cells with the recalculated values based on the X change rate. So if A1 was 5 than after the button hit it would become 10 given the rate is two. So a simple macro would do it probably.
0
Dg83
Mar 12, 2013 at 01:15 PM
Sorry I meant I do have the X change rate
0