- Please Help Explain Step By Step And Show The Vba Thank You 1 (29.79 KiB) Viewed 15 times
PLEASE HELP! EXPLAIN STEP BY STEP AND SHOW THE VBA. THANK YOU
-
answerhappygod
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
PLEASE HELP! EXPLAIN STEP BY STEP AND SHOW THE VBA. THANK YOU
PLEASE HELP! EXPLAIN STEP BY STEP AND SHOW THE VBA. THANKYOU
1. Create a userform with two sets of option boxes. Each set should be within a frame (Select frame element from the toolbox). The first frame should have 4 option buttons Basketball, Baseball, Football, and Soccer. The second frames should have two option buttons "watch on TV" and "go to games". The userform should have Submit and Cancel Button. a. Write a sub to show the userform b. When a user selects one option each from frame 1 and frame 2, you should have appropriate displays such as "Your favorite sports is Soccer and you usually watch on TV" if you selected Soccer and Watch on TV options, after you hit the Submit button. c. The userform should be hidden after submit button is clicked d. If the user clicks Cancel, you should display "You don't want to play this game" and hides the userform 2. Repeat the problem 1, but create a new userform but now replace the optionboxes with checkboxes for the sports frame. The user can select more than one sports and the display should come appropriately such as "You like to football and soccer and you watch on TV". If no boxes are selected, then you should say that "You don't like any sports" or "You don't watch the sports". The code should display only if you click the Submit button. This userform will appear from the second Sub in the module.
1. Create a userform with two sets of option boxes. Each set should be within a frame (Select frame element from the toolbox). The first frame should have 4 option buttons Basketball, Baseball, Football, and Soccer. The second frames should have two option buttons "watch on TV" and "go to games". The userform should have Submit and Cancel Button. a. Write a sub to show the userform b. When a user selects one option each from frame 1 and frame 2, you should have appropriate displays such as "Your favorite sports is Soccer and you usually watch on TV" if you selected Soccer and Watch on TV options, after you hit the Submit button. c. The userform should be hidden after submit button is clicked d. If the user clicks Cancel, you should display "You don't want to play this game" and hides the userform 2. Repeat the problem 1, but create a new userform but now replace the optionboxes with checkboxes for the sports frame. The user can select more than one sports and the display should come appropriately such as "You like to football and soccer and you watch on TV". If no boxes are selected, then you should say that "You don't like any sports" or "You don't watch the sports". The code should display only if you click the Submit button. This userform will appear from the second Sub in the module.