Designing your own Currency Converter
Currency Exchange
Rate
Australian Dollar 2.5
Canadian Dollar 2.2
Cypriot Pound 0.8
Euro 1.4
Japanese Yen 181.5
Maltese Lire 0.6
Swedish Krona 12.6
Swiss Franc 2.1
Turkish Lira 2581139
United States 1.5
Dollar
txt_1 txt_2
1. Open excel
Assign the code:
2. Go to tools, macro, and visual basic editor. txt_2 = txt_1 * 1.5
3. Go to Insert, UserForm
4. Use the toolbox to design your currency converter. You can change the background
colour, font and align text using the properties on the left hand side.
5. You need to give your text boxes and labels names. To do this look at the properties
on the left hand side, click on a text box and view the name. Call one of your text
boxes txt_1 and the second txt_2.
6. You need to decide which currency you want to convert and label this accordingly.
7. Click on the currency button and assign the following code to button:
txt_2 = txt_1 * 1.5 (1.5 is for American Dollars use the currency exchange rate you
have chosen)
8. Click on the play button and test your currency converter.
9. Go back to your UserForm.
10. Draw on another button and label it reset, right click and assign the following code:
txt_1.Value = “ ”
txt_2.value = “ ”
txt_1.setfocus
11. Go back to excel by clicking on the excel button at the top left hand corner, go to
view, toolbars, visual basic. Click on the toolbox, draw a button and label it start.
Right click on the button and view code, assign the following code: UserForm1.Show