Using a Macro with a check box to Change a cell color
 

I'm not very good with macro's, but what I'm trying to do is: I have
start date and an end date, and specific actions that must b
accomplished against the start date. (i.e. aircraft goes in o
10/24/2004 and 10 tasks must be accomplished prior to input, I want t
be able to change a cell to red, yellow, or green depending on how man
boxes are checked against the input date.) Any help would be greatl
appreciated

--
avi8or5
-----------------------------------------------------------------------
avi8or54's Profile: http://www.excelforum.com/member.php...fo&userid=1559
View this thread: http://www.excelforum.com/showthread.php?threadid=27150

Using a Macro with a check box to Change a cell color
 

Depends on where you source the checkboxes from, and what combinations
generate a colour, but here is a start using control toolbox checkboxes

Dim cnt As Long

With ActiveSheet
cnt = -(.CheckBox1.Value + .CheckBox2.Value + .CheckBox3.Value)
.Range("A1").Interior.ColorIndex = WorksheetFunction.Choose(cnt, 3,
6, 10)
End With

--

HTH

RP

"avi8or54" wrote in message
...

I'm not very good with macro's, but what I'm trying to do is: I have a
start date and an end date, and specific actions that must be
accomplished against the start date. (i.e. aircraft goes in on
10/24/2004 and 10 tasks must be accomplished prior to input, I want to
be able to change a cell to red, yellow, or green depending on how many
boxes are checked against the input date.) Any help would be greatly
appreciated.


--
avi8or54
------------------------------------------------------------------------
avi8or54's Profile:
http://www.excelforum.com/member.php...o&userid=15596
View this thread: http://www.excelforum.com/showthread...hreadid=271507