+ Reply to Thread
Results 1 to 5 of 5

Unchecking a checkbox in separate worksheet using VBA

  1. #1
    Registered User
    Join Date
    01-04-2013
    Location
    Maryland
    MS-Off Ver
    Excel 2010
    Posts
    4

    Unchecking a checkbox in separate worksheet using VBA

    Hi,

    I have a workbook containing many different sheets. What I want to accomplish is when I click on a check box on one sheet, I want the check box in a different worksheet to be unchecked. I have form control checkboxes in my workbook, so I used xlOff as the value.

    Here's what I have in my VBA code.

    Worksheets("February").CheckBoxes("CheckBox13").Value = xlOff

    It is giving me the error "Unable to get the CheckBoxes property of the Worksheet class"

  2. #2
    Registered User
    Join Date
    01-10-2012
    Location
    sydney
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Unchecking a checkbox in separate worksheet using VBA

    try this
    Worksheets("February").CheckBox13.Value = True

  3. #3
    Registered User
    Join Date
    01-10-2012
    Location
    sydney
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Unchecking a checkbox in separate worksheet using VBA

    try this
    Worksheets("February").CheckBox13.Value = True

  4. #4
    Registered User
    Join Date
    01-04-2013
    Location
    Maryland
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Unchecking a checkbox in separate worksheet using VBA

    Now it is saying "Object doesn't support this property or method"

  5. #5
    Registered User
    Join Date
    01-04-2013
    Location
    Maryland
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Unchecking a checkbox in separate worksheet using VBA

    Now it is saying "Object doesn't support this property or method"

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1