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

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