Checkbox – Part 1

On the request of Jan ten Berge, a teacher for students with learning disabilities, I will show you how to retrieve text from another worksheet, with the help of a check box.

The intent of Jan is, therefore, to retrieve text from another worksheet, only when a checkbox is selected.
For this, I use a folder with three worksheets.
The first sheet has the check boxes (1) and a formula in the adjacent cells (2).

The second sheet has to retrieve the text.
If you do not want to read this text, you can make the text white or you can hide the column.

The third tab contains the logical value of the check boxes. So, it is either TRUE or FALSE.
It is TRUE if the checkbox is checked and FALSE if it is unchecked.
You can also hide this text, hide the column, or make the text white.

Let us see how to start this procedure.
Select the “Developers” (1) tab.
If you do not see this, then go through Lesson 4 of Excel automation course.
Here we will explain how this is done.

We will move on.
Click the “Insert” (2) button and select the “Check Box” (3) control.

The “Checkbox” control, gives us a option between two values.
It can either be TRUE or FALSE.
When it is TRUE, it is checked. When FALSE, it is not checked.
You then move the mouse pointer over the worksheet (1) and click in the place where you want to place the check box.
This places a check box and the corresponding label in the worksheet (2).

If you don’t want this label or if you wish to change this text, select it and type the text or press the Delete key on your keyboard.

You can change the size of the control by dragging the pads at the corners.

Then right-click the check box and select “Format Control”.

We will continue in the next lesson.

FYI: swotster.com thinks of his students, so also think of swotster.com

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats