You can use the worksheet's change  event. That way at least it won't be
checked on other sheets.

Yes. But dont we have any particular change  event?
thanks for your guidance.

You mean specific to individual cells? No.

You need to ignore the change  if the target is not one of the cells you
want to track changes on.

By using the worksheet change event, you limit the event to just the
worksheet you're interested in. The code  to ignore the event doesn't
take much time  to execute. Certainly not noticeable by people.

Let me check and get back to you if i need any help on the same.
Have a nice day

Thanks for your information.

How do we declare the event in the module? Coudl you please provide me some
sample data if you have?

Is it a correct one?

for Example :
private sub Worksheet("sheet1").change()
.
.
.
.
end sub

I have been wanting to join a group that discussed
about Excel. I hope I am in the right group because from what I"ve read so far,
it seemed like this group is for super advanced Excel users. I'm more of an
intermediate or close to it level.

I've always wanted to know what the purpose of Macro in Excel is?

There are lots of beginners and intermediate people here as well as a few
gurus. You're in good company!

Macros in Excel... Well!! Where to start?! The very simple answer is that
they make life simpler.

Initially macros can be used to *record* things you do. I had a user
recently who got fed up of inserting a Tick symbol from windings all the
time... So he wrote a macro  to do it and set up a button for it. When he
clicks the button now, the symbol is inserted... without having to click
Insert, go to windings, sort through the symbols for the tick and insert it.

They can be that simple.

And of course they can get very complicated too. I think it's true to say
that almost anything you can do in Excel with menus you can automate with a
macro. You can also do very much more.

Have you got a project you are working on at the moment?