Change the currency in another column depending upon the currency code and input value of that currency code in input box

[Dhruvam]

Experts,

Currency code Value All value in USD
CAD 444
CAD 44
GBP 55
GBP 645
GBP 76
GBP 34
USD 432
USD 56

In above table I want to give input to CAD, GBP currency as need to convert in USD.
USD value will remain same in 3rd column as per the currency code in column 1st column.
Requirments are
1) will have to create input box for CAD,GBP currency exchange to USD
2) that input value will multiply with corresponding value in 2nd column
3) and final value will come in 3rd column.
4) USD value will come automatically in 3rd column.

I am new to vba coding.
Waiting for your reply experts.
Many thanks in advance.
- Dhruva