Results 1 to 6 of 6

Uncheck a Check Box using VBA

Threaded View

  1. #1
    Registered User
    Join Date
    07-26-2011
    Location
    melbourne
    MS-Off Ver
    Excel 2010
    Posts
    40

    Uncheck a Check Box using VBA

    Hi
    I have a code which I am trying to use to uncheck a check box but keep getting the error "Unable to get the CheckBoxes property of Worksheet class"

    Can anyone help?

     Sub Checkbox_Uncheck()
    
        Dim Response As VbMsgBoxResult
          
        If Range("A1") = True Then
            Response = MsgBox("Have you cleared all queries allocated to you?", vbQuestion + vbYesNo)
            If Response = vbNo Then
                MsgBox "Please clear all queries before you sign off.", vbInformation
                Sheets("Sheet1").CheckBoxes("Checkbox1").Value = False
            Else
                'Call Reload_financials
            End If
        Else
        End If
    
    End Sub
    Last edited by ashmott; 09-01-2011 at 10:29 PM.

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