Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You will make a program by using Excel VBA. You can add extra to the program. Details are: The following Conversion form must be opened
You will make a program by using Excel VBA. You can add extra to the program. Details are: The following Conversion form must be opened automatically as soon as the excel file is opened. You will choose a conversion type from the combobox. At the upper conversion operations, program does not let the user to enter data to each textbox simultaneously. For example,o The data in the TextBox for Celcius is cleared, when the Textbox of Fahrenheit is activated, and viceversa.o Situation is same for Mile Kilometer and TL USD. To make conversion after entering data, you have to click on CONVERT button.o If you enter value for Celcius and then Fahrenheit equivalence of theCelcius value will be displayed.o If you enter value for Fahrenheit and then Celcius equivalence of theFahrenheit value will be displayed.o Rule is same for Mile KiloMeter and TL USD. Keep digits after dot at all arithmetic operation of the program. Form must be seen as the following When Celcius Fahrenheit is chosen Form must be seen as the following When Mile Kilometer is chosen Form must be seen as the following When TL USD is chosenCONVERSION EXAMPLESOutput screen shoots are taken after clicking CONVERT button Create a sheet named as TLUSD in your excel file. The currency data will bekept in that sheet as in the following format. The conversion between TL and USD will be done by using the data of the lastrow of this sheet. Whenever you click on Go To Currency Form button on Conversion Form, theConversion form will be hidden and following form will be shown. The combobox on the form will contain the dates kept in the first column of TLUSD sheet. When you choose any date, the sell and the buy cost of $ in TL will be displayedbelow the chosen date.When is chosenWhen is chosen If a nonregistered date is forced to enter combobox, the following message willbe displayed. For entering new currency of today, Enter new currency for today part will beused. You will enter the Buy and the Sell cost of $ in TL will be entered. Thenclick the SUBMIT button. Date of today will be taken automatically by a suitable builtin function. After clicking SUBMIT button. Date of the day will be entered automatically. After confirming the amounts by clicking Yes button;The new currency will be added to the lastrow of the TLUSD sheet. After entering new currency, the date combobox will contain the last date.Before adding the new currency, thecontent of the combobox:After adding the new currency, thecontent of the combobox: Whenever Turn To Conversion Form button is clicked, This form will be hiddenand Conversion form will be displayed. At the TL USD sheet, there will be OPEN CONVERSION FORM button.Whenever this button is clicked Conversion for will be shown.Afterclickingbutton
Form must be seen as the following When "Celcius Fahrenheit" is chosen
tableConversionChoose a conversion operation:Celcius FahrenheitFahrenheitGo To Currency FormGoNVERT
Form must be seen as the following When "Mile Kilometer" is chosen
Form must be seen as the following When TLUSD" is chosen
At the upper conversion operations, program does not let the user to enter data to each textbox simultaneously. For example,
The data in the TextBox for "Celcius" is cleared, when the Textbox of Fahrenheit is activated, and viceversa.
Situation is same for "Mile Kilometer" and TL USD".
To make conversion after entering data, you have to click on CONVERT button.
If you enter value for Celcius and then Fahrenheit equivalence of the Celcius value will be displayed.
If you enter value for Fahrenheit and then Celcius equivalence of the Fahrenheit value will be displayed.
Rule is same for "Mile KiloMeter" and TL USD".
Keep digits after dot at all arithmetic operation of the program.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started