+ Reply to Thread
Results 1 to 9 of 9

Currency Converter Please Help!!!

  1. #1
    Registered User
    Join Date
    11-06-2015
    Location
    San Diego
    MS-Off Ver
    2013
    Posts
    82

    Currency Converter Please Help!!!

    Hello Everyone,

    So I have created a customer facing model for my work. Basically customers input their current data ad hardware and it compares prices and costs of their current hardware to our hardware pretty simple it is made with just a bunch of minor formulas. But my boss asked me to create a macro which would convert the whole model from US dollars to other currencies like euro's and british pounds. I have no idea how to do this all I know is that it requires VBA. Can someone please help I would really appreciate it. Also I may not know all the techincal terms about excel so if you could make it noob friendly that would be great.
    Thank you guys!!

  2. #2
    Registered User
    Join Date
    11-06-2015
    Location
    San Diego
    MS-Off Ver
    2013
    Posts
    82

    Re: Currency Converter Please Help!!!

    Hi Guys,
    Sorry I just wanted to add that I was able to create the conversion using if statements and formulas but my boss didnt like it he wanted a macro. Any help would be great.
    Thank you

  3. #3
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Currency Converter Please Help!!!

    Submit a copy of your workbook
    If you are happy with my response please click the * in the lower left of my post.

  4. #4
    Registered User
    Join Date
    11-06-2015
    Location
    San Diego
    MS-Off Ver
    2013
    Posts
    82

    Re: Currency Converter Please Help!!!

    here you go
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    11-06-2015
    Location
    San Diego
    MS-Off Ver
    2013
    Posts
    82

    Re: Currency Converter Please Help!!!

    hello here it is let me know if you can open it

  6. #6
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Currency Converter Please Help!!!

    which cell will determine the units and what cells need to be changed when a unit is changed?

  7. #7
    Registered User
    Join Date
    11-06-2015
    Location
    San Diego
    MS-Off Ver
    2013
    Posts
    82

    Re: Currency Converter Please Help!!!

    cells on input page B19,B20,B27,F22,I22 basically all cell that are currency figures on the input page. The currency pulldown I amde on the iput page was just for the currency formatting. Ideally what I want to do is a have button on the input page with a macro that can just change all the currency cells on the input page.
    thank you

  8. #8
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Currency Converter Please Help!!!

    Here is a simple example of how you could create buttons as you indicated to change from one type to another. Given a time investment, you could incorporate a userform, comboboxes, or a more advanced system.

    Please Login or Register  to view this content.

  9. #9
    Registered User
    Join Date
    11-06-2015
    Location
    San Diego
    MS-Off Ver
    2013
    Posts
    82

    Re: Currency Converter Please Help!!!

    Hi
    Thank you so much for that above quite do what it was hoping I am just very confused I guess. I suppose I want to already have values in cells B19,B20,B27,F22,I22 in the input page which will be in dollars then I want to select the currency I want in cell E7 then click a button on the input page that would convert cells B19,B20,B27,F22,I22 to the currency I selected. I write something I think might work but I may not be on the right track can you please help me.

    Please Login or Register  to view this content.
    I was thinking I could just have a bunch of IF statments that would just multiple the cells by the appropriate figure I need. Any help would be great.
    Thank you
    Last edited by Leith Ross; 11-09-2015 at 11:00 PM. Reason: Added Code Tags

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Currency Converter
    By AnisaF in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-24-2019, 10:07 AM
  2. Currency Converter
    By Bob Phillips in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 12:05 PM
  3. Currency Converter
    By Bob Phillips in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 07:05 AM
  4. Currency Converter
    By Bob Phillips in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 06:05 AM
  5. Currency Converter
    By AnisaF in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  6. [SOLVED] Currency Converter
    By AnisaF in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. [SOLVED] Currency Converter
    By AnisaF in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  8. [SOLVED] Currency Converter
    By AnisaF in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-26-2005, 07:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1