How can I execute a 'macro1' once an entry is made in a cell and enter is pressed?

[rkjudy]

When I open this particular Sheet2, the focus is on cell B10. The value in B10 is initially $0.00. The user then changes this to another dollar value. I need to execute a macro whenever this amount on cell B10 is changed by the user. The macro takes information from newly calculated information (as a result of the change in cell B10) on Sheet1 and places this information on Sheet2. Any suggestions?

[FrankD10]

On the code for Sheet2 enter in the following:

Please Login or Register  to view this content.

[rkjudy]

I'm getting a Compile error: Syntex error. Here is my code. This is placed as code for Sheet2. The workbook opens to Sheet1. I run a macro (GoToPriceWorkup) to go to Sheet2. The macro returns to Sheet1, performs calcs, then goes to Sheet2 and fills some other cells.

Please Login or Register  to view this content.

[FrankD10]

Sorry I should have clarified better. Take of the quotes so it looks like this:

Please Login or Register  to view this content.

If that does not work send me the GoToPriceWorkup code

[Cutter]

@ FrankD10

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.

[rkjudy]

Thanks much. I entered the code as you suggested and it works PERFECT. However, now when I execute another macro that clears and resets the sheet, I get a Run-time error '1004': "Application-defined or object-defined error".

Please Login or Register  to view this content.

The code stops and presents the error on this line:

Please Login or Register  to view this content.

The AllDebits is a named range.

Before I added your suggestion above, this code executely perfectly and I did not get the error. Only after adding your code to sheet2 (which worked perfectly) did I get this error. Any other suggestions?