Answered step by step
Verified Expert Solution
Link Copied!

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 vice-versa.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 4 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 EXAMPLES(Output screen shoots are taken after clicking CONVERT button) Create a sheet named as TL-USD 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 1 $ in TL will be displayedbelow the chosen date.When 31.05.2021 is chosenWhen 1.6.2021 is chosen If a non-registered 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 1 $ in TL will be entered. Thenclick the SUBMIT button. Date of today will be taken automatically by a suitable built-in 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 TL-USD 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
\table[[Conversion],[Choose a conversion operation:],[Celcius - Fahrenheit],[Fahrenheit],[Go To Currency Form],[GoNVERT]]
Form must be seen as the following When "Mile Kilometer" is chosen
Form must be seen as the following When "TL-USD" 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 vice-versa.
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 4 digits after dot(.) at all arithmetic operation of the program.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Securing SQL Server Protecting Your Database From Attackers

Authors: Denny Cherry

1st Edition

1597496251, 978-1597496254

More Books

Students also viewed these Databases questions

Question

3.2. Describe the DSM-5 approach to diagnosing mental disorders ?

Answered: 1 week ago

Question

Why We Form Relationships Managing Relationship Dynamics?

Answered: 1 week ago