Converting all displaying values to other currencies

**VBA Noob** · 11-26-2006, 03:35 PM

Carim,

Could you not use some code and toggle results triggered by cell A1. Start with sterling then

If Cell A1 = Swedish then format values as Swedish and x values by 13.5

If cell A1 = Pounds then Format values as Sterling divided by 13.5

VBA Noob

**Carim** · 11-26-2006, 03:47 PM

VBA Noob,

You are absolutely right ... (as usual ..)

With an event macro, Target.Address=A1 showing the currency selected by the user ... it is feasible AND it is an elegant solution, provided our user is prepared to maintain, preferably on a separate sheet, all the exchanges rates needed to convert his "cable"-based original worksheet ...

Cheers
Carim

**VBA Noob** · 11-26-2006, 03:49 PM

Carim,

True

Guess you could use a define name value if it was a semi static currency that didn't change often

VBA Noob

**Nib** · 12-03-2006, 05:13 PM

I don't understand what you mean :S

**VBA Noob** · 12-03-2006, 05:19 PM

Hi,

This link might help you

http://www.excelforum.com/showthread...light=currency

VBA Noob

**Nib** · 12-04-2006, 05:33 PM

Ah thanks, that sounds much better than the solution I'm currently using

**VBA Noob** · 12-04-2006, 05:36 PM

No Problem

Carim gets th brownie points for this one

VBA Noob

Converting all displaying values to other currencies

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions