Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Checkbox dependent on a checkbox

  1. #1
    New Member
    Join Date
    Aug 2002
    Posts
    36
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •