Capture when a cell is left without changing any data. Worksheet_Change does not work

[mgCulver]

Hi.

How do I capture when a cell loses focus when nothing has changed within the cell. Worksheet_Change event only works when a change has manually been made to a cell. If nothing is changed, the Worksheet_Change event is not fired.

I think I have asked this before however, I can't find and answer.

Thanks,

Mike C

 

[bebo021999]

May be:
"Worksheet_Calculate" even works?

 

[mgCulver]

Hi Bebo.

I tried Worksheet_Calculate with no luck.

Thx

 

[bebo021999]

please provide the macro here

 

[StephenCrump]

It sounds like you need the Worksheet_SelectionChange event. You may also need to store the previous value(s) of the monitored cell(s) to determine if changes have been made.

Can you please provide more detail, e.g.

- how many cells do you want to monitor?
- how should the code allow for the selection including monitored and non-monitored cells?
- should the code always trigger if the user moves away from the monitored range? Or only if the user moves away without making changes?
- what about moving to other worksheets? Other workbooks?

 

[mgCulver]

It sounds like you need the Worksheet_SelectionChange event. You may also need to store the previous value(s) of the monitored cell(s) to determine if changes have been made.

Can you please provide more detail, e.g.

- how many cells do you want to monitor?
- how should the code allow for the selection including monitored and non-monitored cells?
- should the code always trigger if the user moves away from the monitored range? Or only if the user moves away without making changes?
- what about moving to other worksheets? Other workbooks?

That's how I got around it. Just haven't had time to test it. There are 6 cells that I'm monitoring. The routine generates an invoice based on activity in other workbooks. If the user wants to change values in one of the cells they can, however if the invoice is OK, they can step through and print the invoice without changing any data.

Appreciate your comeback. And you are correct about using the Worksheet_SelectionChange event.

This query can be closed.

Thanks for your help.

 

[mgCulver]

please provide the macro here

Resolved the problem using Worksheet_SelectionChange. Thanks for you help.