Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Check Box Operation Linked to Cell

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Check Box Operation Linked to Cell

Resolved · Low Priority · Version 2003

Reply Tue 26 Oct 2010, 14:06Delegate David said...

David has attended:
Excel Advanced course
Excel Advanced course

Check Box Operation Linked to Cell

Hi,

How can I get a random cell to change from True to False on the operation of a check-box? I.e. if a check-box is ticked the cell will show "True"; if check-box is un-ticked the cell will show "False."

Many Thanks,
David

For upcoming training course dates see: Pricing & availability

Reply Fri 29 Oct 2010, 16:12Trainer Simon said...

RE: Check Box Operation Linked to Cell

Hi David,

Thank you for your question.

If you go to View - Toolbars - Control Toolbox and then select the checkbox tool and draw a text box on your spreadsheet.

Once drawn, increase the length of the control to see the label and edit the label if necessary.

Right click over the checkbox and choose View Code. Make a note of the name of the checkbox by right clicking and Properties.

Copy and paste the following code between Private Sub CheckBox1_Click and End Sub:

If CheckBox1.Value = True Then

Range("a3") = "True"

Else

Range("a3") = "False"

End If

Close the Visual Basic window down and turn off design view to use the checkbox. On the control toolbox Design Mode is the first option.

I hope this answers your question.

Regards

Simon

Excel articles

· How Teachers Are Using Microsoft Excel To Enhance Learning in the Classroom
· How To Use The Research Functionality In Excel 2010
· Microsoft Excel Training: Essential for Today's Employees
· Getting To Grips With Gantt In Excel
· How To Link Between Spreadsheets In Excel

Please browse our web site to find out more about
excel computer training and other Microsoft training courses.

Excel tip:

Using the Quick Access Toolbar in Excel2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Excel hints and tips