Currency Format via VBA

T

tgorath

Hi,

I have to solve a problem with EXCEL 2000 and/or Excel 2002. The
current Currency format is $. All money related cells are formated
using the "currency format $". What I have to do is "relatively"
simple. The user will enter a new currency symbol using a dialog once
the spreadsheet is opened. This symbol either € or £ or ¥ has to be
the new format for ALL money related cells. How can that be done?

Thanks in advance,
Thiemo Gorath
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

setting currency symbol in vba 2
Excel does not accept text format! 0
VBA Code to Change Currency Format 7
Currency List Dropdown for Worksheet 2
Summing based on currency format of Cell 2
Currency conditional formatting 0
Programmatically Access to Symbol Dropdown in Format Cells Dialog 2
How to add new currency Symbol in Format/Cell/Currency 2

Top