Currency List

James_Latimer

Active Member
Joined
Jan 20, 2009
Messages
415
Excel 2016.
Hello Excellers.
Here is the 'stupid question du jour'... is there any way to loop through the list of currency options using VBA? I'm referring to the options when you format a cell, click currency and then you get a long list of options (currency symbol and region).
I'm wanting to create a routine that will loop through all currency cells and update the symbol based on user selection, i'm using a find/replace function at the moment but it is somewhat 'flaky'.
Any advice would be sincerely appreciated.
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

Watch MrExcel Video

Forum statistics

Threads
1,108,970
Messages
5,525,961
Members
409,673
Latest member
Riseee

This Week's Hot Topics

Top