Reference no: EM13933454

Please refer to attached PDF documents for original questions.

1. Create a user form that contains the usual OK and Cancel buttons. It also should contain 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 the event handlers and code in a module 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, the message "Sorry you don't want to

play." should appear.

2. Repeat the previous exercise, but now make the controls checkboxes, not option buttons. Change the message in case the

user clicks OK to something appropriate, 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 checkboxes are checked (including none being checked).

3. Create a user form that contains the usual OK and Cancel buttons. It should also contain a list box of the type where the

user is allowed to select only one item from the list. Write a UserForm_Initialize sub that populates the list with the states

Illinois, Indiana, Iowa, Michigan, Minnesota, Ohio, Pennsylvania, and Wisconsin (in this order), and selects Indiana by default.

Then write the event handlers for the buttons and code in a module so that when the program runs, the user sees the form. If

she chooses an item from the list and then clicks on OK, she should see a message such as, "You live in Ohio." If she clicks

on Cancel, she should see the message, "You must not live in a Big Ten State."

4. The file Big Ten Teams.xlsx contains the school and mascot names for the Big Ten teams in a range named Teams. (It

doesn't include Nebraska yet.) Create a user form that contains the usual OK and Cancel Buttons. It should also contain a list

box of the type where the user is allowed to select only one item from the list. Set its RowSource property to Teams, so that

the list box is automatically populated from the list in this range. Also, set its ColumnCount property to 2, so that schools and

mascots both appear in the list box, and set its ColumnHeads property to True, so that each column has an appropriate

heading. Write a UserForm_Initialize sub that selects Indiana by default. Then write the event handlers for the buttons and

code in a module so that when the program runs, the user sees the form. If he chooses an item from the list and then clicks

on OK, he should see a message such as, ''You must root for the Indiana Hoosiers." If he clicks Cancel, he should see the

message, "You must not be a Big Ten fan." (Hint: In online help, look up the BoundColumn property of a list box and how it

controls the Value property.)