This page has 0 threads | Add post

Exercises

Finding our exercises useful? Please consider helping us to share more!

Software ==>	Excel VBA Macros (52 exercises)
Topic ==>	Messages and variables (4 exercises)
Level ==>	Average difficulty
Subject ==>	VBA training

Use input boxes in Excel VBA to ask a user to enter details for a dating agency application.

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Before you can do this exercise, you'll need to download and unzip this file .

Open the WODA Application.xlsm file. Your task is to create subroutines which can be attached to the two buttons on the application form.

The text on the buttons should provide a clue as to what they should do.

Create a subroutine which you can attach to the Add Details button. A basic outline for this procedure could be:

Declare variables to hold each value the user will enter.
Use input boxes to ask the user to enter each value and capture the result in the variables you have declared.
Write the value of each variable into the appropriate cell on the worksheet.
Present a message which informs the user that the application is complete.

For reference, the code to capture the value of an input box is:

MyVariable = InputBox("Type something")

Right-click on the Add Details button and choose to assign the procedure you have written.

Click the button to check that the system works: