+ Reply to Thread
Results 1 to 4 of 4

Problem with Check Box Macro

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    01-21-2013
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    258

    Problem with Check Box Macro

    Hey guys,

    Having a wee problem with this code, strange this is that it was working before, and I'm not getting any errors now, but it doesn't work.
    Pretty much just want to check the box and have 'Approved' appear in that cell.
    I wrote another code for a seperate checkbox pretty much the same but it posted 'Review' in the same cell, and thats when it stopped working, but I've since deleted that macro but still cant get this one to run. Would I have to clear R39 at the beginning each time I run one of these macros? Can anyone spot whats wrong with this code?
    Many thanks for any advice in advance!

    Private Sub CheckBox3_Click()
    Dim WS As Worksheet
    
    Set WS = ThisWorkbook.Sheets("Transmittal Sheet")
        With WS
            If CheckBox1.Value = True Then
                .Cells(39, "R") = "Approval"
            End If
        End With
    End Sub

  2. #2
    Forum Contributor
    Join Date
    01-21-2013
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    258

    Re: Problem with Check Box Macro

    Actually, I figured it out.

  3. #3
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167

    Re: Problem with Check Box Macro

    If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  4. #4
    Forum Contributor
    Join Date
    01-21-2013
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    258

    Re: Problem with Check Box Macro

    Haha, okay but the solution was that I'm an Idiot who was trying to be speedy whilst doing coding.

    I copied and pasted
    If CheckBox1.Value = True Then
    with the rest of the code.

    Forgot to change it to checkbox2, simple mistake!

+ 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