Discussion Locked

Dynamically Changing Currencies

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I'd like to know if it's possible within an Excel spreadsheet to say have a check button to select a currency option and then do a vlookup function select a cell and then display it with the appropriate currency symbol.

In other words if I select "dollar" the cells are displayed with the "$" currency symbol but if then want to use a set of Euro tables then the display cell would switch from having the "$" currency symbol to the Euro Symbol.

Thanks.

1 reply

by rlk2k

You could record a macro of you formatting the cells with the dollar sign, and then create a macro button and attach the macro to the button action.

This discussion is closed to new replies.