?
Solved

Run a Sub on Check and Uncheck

Posted on 2010-08-19
5
Medium Priority
?
215 Views
Last Modified: 2013-12-25
Excel 2010

When checkbox is checked I want the first part to run. when unchecked I want the second part to run....is this possible using one checkbox control? Please help.

Private Sub CommandButton1_Click()
 If Value = True Then
    Range("C3").Select
    ActiveCell.ClearFormats
    ActiveCell.NumberFormat = "M/D/YYYY"

  Else
    Range("C3").Select
    Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlBetween, _
        Formula1:="=TODAY()", Formula2:="=TODAY()+15"
    Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
    With Selection.FormatConditions(1).Font
        .Color = -16777024
        .TintAndShade = 0
    End With
    With Selection.FormatConditions(1).Interior
        .PatternColorIndex = xlAutomatic
        .ThemeColor = xlThemeColorAccent2
        .TintAndShade = 0.799981688894314
    End With
    Selection.FormatConditions(1).StopIfTrue = False

 End if
End Sub

Open in new window

0
Comment
Question by:BigBadWolf_000
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 17

Accepted Solution

by:
calacuccia earned 2000 total points
ID: 33480684
Change your test to the code beneath and it should work (you'll have to change CheckBox1 to whatever name the control has.

If CheckBox1.Value = True Then



0
 
LVL 58

Expert Comment

by:cyberkiwi
ID: 33480696
Is the Checkbox the CommandButton1 itself? Or another control?
0
 
LVL 14

Author Comment

by:BigBadWolf_000
ID: 33480732
Yes the CheckBox1_Click() itsself. (CommandButton1 was a typo)
CheckBox1.Value did the trick thank you  calacuccia:
0
 
LVL 58

Expert Comment

by:cyberkiwi
ID: 33480743
If Sheets("Sheet1").Shapes("Check Box 1").DrawingObject.Value = 1 Then
  ' it is checked
Else
  ' it is not checked
End if
0
 
LVL 14

Author Comment

by:BigBadWolf_000
ID: 33480761
Thanks for that code snippet too cyberkiwi:
0

Featured Post

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

800 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question