Results 1 to 6 of 6

Checkboxes to enable button

Threaded View

  1. #1
    Registered User
    Join Date
    07-03-2014
    Location
    Chino Hills, CA
    MS-Off Ver
    2007/2010
    Posts
    3

    Checkboxes to enable button

    Hey community,

    First time posting here and its been a couple days trying to figure this macro out. Before flaming, I'm pretty new at VBA/Macros and have done extensive research. I have a series of 4 checkboxes that needs to be checked off before a button is enabled to be pushed. For some reason I cant find the resolution or make this work.

    This is what I have so far:

    Private Sub CheckBox1_Click()
        If CheckBox1 Then
        ActiveSheet.Button4.Enabled = True
     Else
        If Not CheckBox2 And Not CheckBox3 Then
        ActiveSheet.Button4.Enabled = False
     End If
     End Sub
     Private Sub CheckBox2_Click()
        If CheckBox1 Then
        ActiveSheet.Button4.Enabled = True
     Else
        If Not CheckBox3 And Not CheckBox4 Then
        ActiveSheet.Button4.Enabled = False
     End If
     End Sub
     Private Sub CheckBox3_Click()
        If CheckBox1 Then
        ActiveSheet.Button4.Enabled = True
     Else
        If Not CheckBox4 And Not CheckBox1 Then
        ActiveSheet.Button4.Enabled = False
     End If
     End Sub
     Private Sub CheckBox4_Click()
        If CheckBox1 Then
        ActiveSheet.Button4.Enabled = True
     Else
        If Not CheckBox1 And Not CheckBox2 Then
        ActiveSheet.Button4.Enabled = False
     End If
     End Sub
    With that...Flame suit on!

    Thanks for your help.

    -Ryan
    Last edited by ryryAP2; 07-11-2014 at 04:03 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Button enable and disable...
    By Will03 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-25-2013, 10:00 AM
  2. [SOLVED] enable a disabled button
    By CharlieZangel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-18-2012, 07:32 PM
  3. Command button Enable using VBA
    By psatkar in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-10-2006, 05:50 AM
  4. Using Checkboxes to enable/disable vb
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-15-2006, 12:45 PM

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