Converting dollars into euros

[Niko]

Is it possible to convert dollars automatically into euros in Excel 2002? I
have downloaded automatically updating currency rates using MSN Money. Now I
would want to make a cell in which I could enter the amount in dollars and
see the amount in euros in the same cell. Is this possible?

Regards,
Niko

 

[Bob Phillips]

Just multiply the amount by the exchange rate.

SO if the amount is in A1, and the exchange rate is in C3 on Sheet2, use

=A1*Sheet2!C3

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Niko]

Yes, that's how I add the formula to another cell. But I would like to do
the similar thing Excel does when it, for example, converts numbers to
dates. So if I write the amount to A1 (in dollars) I would like to see it in
euros in A1, just like I can enter 1234 to A2 and see it as 18.5.1903 if the
cell is formatted as date. Is this kind of conversion possible with
currencies?

Regards,
Niko

 

[Bob Phillips]

With VBA you can

Private Sub Worksheet_Change(ByVal Target As Range)
Const WS_RANGE As String = "A1:A10" '<== change to suit

On Error GoTo ws_exit
Application.EnableEvents = False

If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then
With Target
.Value = .Value * Worksheets("Sheet2").Range("C3").Value
End With
End If

ws_exit:
Application.EnableEvents = True
End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Rick Rothstein \(MVP - VB\)]

Yes, that's how I add the formula to another cell. But I would like to do

the similar thing Excel does when it, for example, converts numbers to
dates. So if I write the amount to A1 (in dollars) I would like to see it
in euros in A1, just like I can enter 1234 to A2 and see it as 18.5.1903
if the cell is formatted as date. Is this kind of conversion possible with
currencies?

If your dollars are in A1, put your conversion formula in A2 and format A2
for Euros by going into Format Cells, selecting Currency from the Category
list and picking X Euro (X 123) from the Symbol combo box (where the X is
going to be the Euro symbol in the display).

Rick

 

[Niko]

The code does exactly what I wanted. Thank you very much!

Regards,
Niko

 

[Rick Rothstein \(MVP - VB\)]

Sorry, ignore my response... I missed the part where you said your wanted
the result in the same cell you entered the amount in.

Rick