Question: PLEASE USE VBA IN EXCEL Exercise 1 ( 1 0 0 points ) Improve the Bank Account Management Application as follows: 1 . Delete all

PLEASE USE VBA IN EXCEL
Exercise 1(100 points)
Improve the Bank Account Management Application as follows:
1. Delete all the buttons in the Account spreadsheet with the exception of the Exit Button
2. When the Start button is clicked then the Choose operation form is shown
3. Write the event handler for the Initialization of the form, so that the form is shown it appears in
the following way:
4. Write the event handler for the Cancel Button of the Choose Operations form
5. Write event handler for the OK button of the Choose Operations form
6. Modify the main subroutine so that:
If the user selected New Deposit then the NewDeposit Sub is called
If the user selected New Withdrawal then the NewWithdrawal Sub is called
If the user selected Deposit Sum then the DepositSum Sub is called
If the user selected Withdrawal Sum then the WithdrawalSum Sub is called
If the user selected Visualize Account the spreadsheet Account is shown

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!