Currency changer

[tarynnl]

I need to a button to add onto a spreadsheet , so that when it is
pressed a option box appears prompting user to type in a currency
format (or select a currency format) and it will automatically change
the currency format of the numbers on the spreadsheet.
I think a macro/VB script will do this but dont know how to write one

 

[Sean Connolly]

Hi tarynnl,

Perhaps I'm missing something, one can but you don't *need* to write VBA
code to achieve this.

Unless there's some valid reason that you (or your users) would want to
prevent it, why not just use the native, out-of the box functionality of
Excel as follows...

1. Select the cell (or cells) required.
2. Right mouse click will bring up a short-cut menu. Choose "Format Cells..."
(Selecting "Cells" from the "Format" menu of Excel's main menu bar or Ctrl+1
will do the same thing).
3. On the "Number" tab of the dialog box that appears, choose either
"Currency" or "Accounting" from the Category list.
4. Enter the number of decimal places that you'd like to display and then
choose the desired currency symbol from the Symbol drop-down list.
5. Click OK and note that your cell(s) are now formatted with the desired
currency symbol.

That changes the *format* and display of the underlying numbers in the cell
(but not the numbers themselves). If you're actually trying to convert the
original numbers from your local currency into some other currency (say
EUR->GBP for example), then that is a completely separate question.

HTH, Sean