| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing cell format with VBA?
I want to have a button/control that change the a cell/columns currency for example I want the result to show the result in $ or SEK. Is it possible to do this? Maybe with Macro/VBA? /biben ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing cell format with VBA?
Excel can label a currency, but it has no knowledge of the conversion
factor. You would have to write code that applies the appropriate conversion factor conditionally (knowing what is currently stored). -- Regards, Tom Ogilvy "biben" wrote in message ... I want to have a button/control that change the a cell/columns currency for example I want the result to show the result in $ or SEK. Is it possible to do this? Maybe with Macro/VBA? /biben ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing the cell format doesn't change existing cell content | Excel Discussion (Misc queries) | |||
| Changing contents of cell based on Cell Format | Excel Worksheet Functions | |||
| Changing Cell format | Excel Discussion (Misc queries) | |||
| Cell format changing on the fly | Excel Worksheet Functions | |||
| Why does my format keep changing in the cell? | Excel Discussion (Misc queries) | |||
Linear Mode
