Confirmation Popup Window on Cell Change & Cell Delete. (3 conditions)

Stick this in the worksheet module:

Please Login or Register  to view this content.

Thank you OllyXLS for the fast response. The code is awesome. All 3 conditions are satisfied

Is there anyway to avoid VBA run-time error '13" Type mismatch, when performing the actions with multiple cells highlighted?

1) deleting multiple cells at once.
2) while multiple cells highlighted, enter data on selected cell.

I'm sorry these are nitpicking for perfection, but I would love it even more with these things!

Thanks again! Rep+

Originally Posted by smk224

Thank you OllyXLS for the fast response. The code is awesome. All 3 conditions are satisfied

Is there anyway to avoid VBA run-time error '13" Type mismatch, when performing the actions with multiple cells highlighted?

1) deleting multiple cells at once.
2) while multiple cells highlighted, enter data on selected cell.

I'm sorry these are nitpicking for perfection, but I would love it even more with these things!

Thanks again! Rep+

Try changing the code to:

Please Login or Register  to view this content.

It's a quick fix, which prevents the runtime error if multiple cells are selected, and just warns that undo is unavailable (statusbar message).

There is probably a way to provide the undo functionality you want for multiple cell ranges, by storing original values in an array, but I'm afraid I don't really have time to work that one through today.

Okay - try this, which should now handle multiple cell selections:

Please Login or Register  to view this content.