View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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