Workbook SheetChange event not firing

Can someone please tell me why this event is not firing, i already checked and the application event is true. Is there something wrong with the code below that i am overlooking, i am still learning VBA so i may have missed an error.

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

Originally Posted by HerryMarkowitz

Try attached file...

Thank you for responding, but your spreadsheet only works if i copy and paste the required information in the cell, if i type the information in doesn't fire, not sure why.

Originally Posted by JOHN H. DAVIS

Maybe:

Please Login or Register  to view this content.

Thank you John Davis, your method worked perfectly. Why would the method i was using not work but using the intersect method did?

Originally Posted by HerryMarkowitz

Type the information, then do not press enter, press right arror key...

HerryMarkowitz, I did what you said and it worked but why would it fire with the arrow key but not with the enter key? If a user presses enter instead of the arrow key the result is going to mess up the result i am trying to achieve.

I tried your code as well, it seems to work with Target.row vrs Activecell.row.

You're using a Selection Change Event vrs. a Change Event.

You are using:

Please Login or Register  to view this content.

I think you want:

Please Login or Register  to view this content.