+ Reply to Thread
Results 1 to 2 of 2

VBA Function - Exchange Rates

  1. #1
    Registered User
    Join Date
    04-18-2012
    Location
    england
    MS-Off Ver
    Excel 2010
    Posts
    8

    VBA Function - Exchange Rates

    Hi

    I want to build a VBA function that converts one currency to another. I'm pretty new to using Functions and have spent way too long trying to figure this out.

    I want something like this:

    Exchange = (VAL, CURRENCYFROM, CURRENCYTO)

    So the user can enter the value, currency from and to and it'll give them the exchange rate. I want this on a function so that it can be used in any report rather than having to always open a separate worksheet for this.

    Ideally, I wanted this to look into a spreadsheet on a server so it will always have the latest rates, but I couldn't get this to work so happy to list all the rates in the code but still having no luck.

    Any clues would really be appreciated

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,594

    Re: VBA Function - Exchange Rates

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Ben Van Johnson

+ 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. [SOLVED] Foreign Exchange rates, auto update
    By Geoffo123 in forum Excel General
    Replies: 1
    Last Post: 03-02-2015, 06:13 PM
  2. Exchange rates display
    By akhmoud in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-02-2013, 02:02 AM
  3. Match up currency exchange rates and calculate
    By zl068565 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-18-2013, 02:46 PM
  4. [SOLVED] Calculating multiple exchange rates
    By Merlinti in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-20-2012, 03:42 PM
  5. Formula for exchange rates
    By msincome in forum Excel General
    Replies: 1
    Last Post: 03-29-2011, 03:14 AM
  6. CDN/US closing exchange rates today to 5 yrs ago
    By Xx7 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-06-2011, 06:25 PM
  7. matching dates and currency exchange rates
    By LoriL in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 04-08-2009, 06:04 AM

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