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