Question

Use VBA Code to

Create a form that contains the usual OK and Cancel buttons. It also should con- tain two sets of option buttons, each set placed inside a frame. The captions on the first set should be Baseball, Basketball, and Football. The captions on the second set should be Watch on TV and Go to games. Then write appropriate code so that when the program runs, the user sees the form. If the user makes a couple of choices and clicks OK, he should see a message like, "Your favorite sport is basketball, and you usually watch on TV." If the user clicks Cancel or the X but- ton, the message "Sorry you don’t want to play." should appear.
Repeat the previous exercise, but now make the controls checkboxes, not option buttons. Change the message in case the user clicks OK to something appropri- ate, such as, "You like baseball and basketball, and you like to watch on TV and go to games." The message should be appropriate, regardless of which check- boxes are checked (including none being checked). Suppose you have a form with quite a few text boxes and possibly some other controls. Write an Initialize sub that loops through all controls and, if they are text boxes, sets their Value property to a blank string.

Answer 1

1. Initialize a form with buttons and option buttons, displaying a sport and watching preference message based on user choices.

2. Replace option buttons with checkboxes, modify code accordingly, and display a comprehensive message on checkbox selections.

3. Implement an Initialize sub to clear text box values, ensuring a clean slate for user input.

Step-by-step explanation:

In the first step, a form is initialized with buttons and option buttons for sports preferences. The code is designed to respond to user choices when clicking OK or Cancel. If OK is selected, a message is displayed based on the chosen sport and watching preference. Choosing Cancel or closing the form triggers a message indicating a lack of interest in playing any sport.

Moving to the second step, the option buttons are replaced with checkboxes to allow multiple selections. The code is then modified to accommodate these changes. The message displayed upon clicking OK dynamically adjusts based on the selected checkboxes, providing a comprehensive summary of the user's preferences, including which sports they like and whether they prefer watching on TV or attending games.

In the third step, an Initialize sub is introduced to streamline the form's initialization process. This sub loops through all controls on the form, identifying text boxes, and sets their values to an empty string, ensuring a clean slate for user input. This enhances user experience by presenting clear and unambiguous fields for entering information.