Run macro when enter key pressed in certain range

[mr_mango81]

I need to be able to run a macro called "Daily_Fuel_Line_Save2" when the enter key is pressed in any cell in the range A10:F10, but I still need to be able to use the tab key between the individual cells and change values in this range before starting the macro.

I already have the following code on the sheet which I would also like to keep.

Please Login or Register  to view this content.

Can anyone help me with this issue??

[Leith Ross]

Hello mr_mango81,

This should now do what you want...

Please Login or Register  to view this content.

[mr_mango81]

Thanks Leith, but the enter key doesn't seem to run the macro when pressed in any of the cells the in the range A10:F10. The other part of the code still seems to work fine though.