Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Event with Check Box?
I want to fire code based on a check box being checked or unchecked. The
worksheet change event doesn't seem to recognise the True/False changes when I check box is checked. My code is simple. Private Sub Worksheet_Change(ByVal Target As Range) 'If Not Application.Intersect(Range("i31:i60"), Target) Is Nothing Then If Not Intersect(Target, Range("i31:i60")) Is Nothing Then MsgBox "test" End If End Sub Where column I contains true or false as a cell value based on the checkbox. Can I get this to fire off of check boxes themselves? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MsgBox in Enter event causes combobox not to run Change event | Excel Programming | |||
Paste Event Check | Excel Programming | |||
Change event and calculate event | Excel Programming | |||
Change Event.....Spell Check | Excel Programming | |||
change event/after update event?? | Excel Programming |