Conversion of USD TO CAD

[Changez]

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

 

[Nightlytic]

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

 

[Changez]

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

 

[Nightlytic]

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.

 

[Changez]

That's amazing! Thank you so very much.

 

[Nightlytic]

No problem