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.
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.
