• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conversion of USD TO CAD

C

Changez

New Member
Hello Friends,

I am looking for a vb code to convert all values in column B from CAD TO USD by the exchange rate shown in cell L1 by choosing a radio button as shown in the attached sample workbook. Your help is much appreciated. Thanks

Also, is there a way to use indirect function on top of the vb code as I'd like to try both approaches? Thank you very much
 

Attachments

  • Sample.xlsx
    16.6 KB · Views: 5
Hi Changez, see attached vba.

I'm afraid I don't quite catch what you mean by an indirect function so you might clarify if you still want that :)
 

Attachments

  • Chandoo rates change example.xlsm
    23 KB · Views: 6
Pls scratch the Indirect function comment, can you please help me with a vb code to convert the value in column B to USD based on the exchange rate defined in cell L1? Thanks
 
That's done in the file I attached in my first reply, just hit the buttons and values in column B update for the rate selected. You can flick between CAD and USD. Examine the code to expand the selection to however big your actual data is.
 
You must log in or register to reply here.
Back
Top