Thanks Gary.

I think you are able to answer my another post on 1/9/2008. i.e.,

I wanted to write a VBA code which supports the following

L-Leave, S-Start, E-End, D-Date, CL- Casual Leave, SL- Sick Leave

Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu
Fri Sat Sun
Name L-S-D L-E-D Type 01 02 03 04 05 06 07 08 09 10 11 12 13
Vinod 3 9 CL CL CL CL CL CL
Chris 7 8 SL SL SL
Micale 2 2 CL CL

My Requirement is If I enter 3 values (L-S-D, L-E-D, Type ) then only the
event should be fired (if any one of 3 values is not available no need to
fire event) which does the action, the leave type should be filled in it's
respective date which excludes "Sat, Sun and Holidays (Holidays list is
displayed at A1:M1) ". After this L-S-D, L-E-D, Type cell values need to be
cleared which followed by fillin color with Red for CL cells and Yellow for
SL cells.

If the same employee applies another time leaves in the same month again I
can fill L-S-D, L-E-D AND Type values. i.e as and when require I have to fill
the data.

Note: previous values results should not be wiped off.

In other words:
when ever an employee applies leave before the leave date only I will enter
the data. And again the same employee apply further leaves in the same month
then I have to enter details at L-S-D, L-E-D and Type.

Advanced Thanks,
Vinod


"Gary''s Student" wrote:

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("C1:C10")) Is Nothing Then Exit Sub
MsgBox ("cell " & Target.Address & " was changed")
End Sub


--
Gary''s Student - gsnu200764