Hello

I typed this following code into Visual Basic for Excel 2007;



Sub CurrencyConverter()

Sheets("Currency").Select
Range("A3,B5,B7").Select
Selection.ClearContents
Range("B3:B9").Select
Selection.ClearContents
Range("A3").Value = InputBox("What country's Currency.", "Enter")
Range("B5").Value = InputBox("What is todays exchange rate from Pounds.", "Enter")
Range("B7").Value = InputBox("How much money do you want to exchange.", "Enter")
Range("B9").Select

End Sub



thing is I can't get the results loaded into cell B9... I need cells B5 multiplied by B7... really appreciate it if you can help!