Checkbox dependent on a checkbox

broadpipe

New Member
Joined
Aug 12, 2002
Messages
36
as a final q on checkboxes -
I need to code so that if a checkbox on sheet1 is ticked then the checkbox on sheet2 is available, however when the checkbox on sheet1 is not checked, the checkbox on the sheet2 is unavailable.
This message was edited by broadpipe on 2002-08-20 07:03
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Mudface

MrExcel MVP
Joined
Feb 18, 2002
Messages
3,339
In design mode, double-click on the checkbox on Sheet1 and enter either of the following lines of code depending on whether you want to simply hide or actually disable the checkbox on sheet2. Change the Sheet2.CheckBox1 to the sheet number and checkbox number/ name as appropriate: -

Code:
Sheet2.CheckBox1.Visible = CheckBox1.Value 'hides/ shows checkbox
Sheet2.CheckBox1.Enabled = CheckBox1.Value ' disables/ enables checkbox
 

Watch MrExcel Video

Forum statistics

Threads
1,095,541
Messages
5,445,083
Members
405,315
Latest member
ao5835403

This Week's Hot Topics

Top