VBA Events

All, am a very novice Excel VBA "coder" (that's a stretch), however, reasonably good with Excel primary functions. Desperately need some help after fumbling with the following functionality need that clearly needs VBA code.

For an individual row when a value is changed from "No" to "Yes", want cells to be updated (overwritten) from other values in the same row based on evaluation of another field value. Following this event, reset the "Yes" to "No" and update the time stamp when the update was made.

Have attached a modified excel spreadsheet that contains the fundamentals of what's being sought after...

Am sure someone this is simple but I'm tied in knots at this point.

Any help appreciated!

Thanks in advance,

I'll also throw something into the garden.

In the Sheet1 module:

Please Login or Register  to view this content.

Kod umożliwia wybór w wielu komórkach jednocześnie (np. zaznaczenie kilku komórek w kolumnie C, wpisanie w aktywną komórkę 'Yes' i zatwierdzenie wpisu poprzez Ctrl+Enter).

Artik

Thank you very much for your reply....greatly appreciated!

Thank you! Really appreciate it......

Thank you...especially adding the MsgBox code....very much appreciated!