How to run macro when value of cell is entered

It's a simple question...

I have a macro that requires a information from the user to be activated.

He would fill the cell and when he hits enter the macro starts running.

Tks in advance...

Use the worksheet change event.

Kind of like this:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

This would be an easy way to do that. You could also adjust the <, >, or = in the first line of the code so that it would run only if those conditions are met. This will rum if the value isnt zero.

Clergh, will this macro activate the called macro whenever a user enters a value in the determined cell?

Yes whenever a value is entered into the cell it will run the macro, unless the value entered is a zero length string.