Monitor multiple cells for an input event

Below is code supplied by JBeaucaire and it works exactly as I requested. However, I need this to happen for multiple cells.

The cells that I need to monitor are B10, B12, B14.... through B96 and F, J, N, R columns for the same rows. The input values will be stored in cells AM10, AM12, AM14 .... through 96 for the B column results. Then for F, J, N, R will be AQ, AU, AY and BC respectively.

Additionally, when B10 has an input, and the user input box displays for the number of hours, there is a cancel button available, but it does not work. How can I exit the loop and clear contents of B10 if the "Cancel" button is clicked in the dialogue box.

I know I'm asking alot. thanks in advance.

Please Login or Register  to view this content.

I would remove the ws_Activate macro completely, that's impractical for the increased scope. Then this should work since your column associations are consistently 37 columns apart.

Please Login or Register  to view this content.

What do you mean? The hours are a requirement aren't they?

Then perhaps:

Please Login or Register  to view this content.