modify target command code to prevent type 13 mismatch

I did a previous post that was solved (click on the link before reading on):

http://www.excelforum.com/excel-programming/778999-using-the-target-command-to-start-user-form-macro.html"
However, when I was performing scenarios where this code would 'fail' as a way to test it, I ran into one of the easiest ways it fails and would like to know how the code can be modified to fix this.

When you change the value in more than one cell via dragging the cursor, I get an

PHP Code: 

error code 13 type mismatch 


,

which I think I understand why and that's because my code is expecting a single cell change and multiple cells are being changed. I just don't know how to modify the code so that when a user would do this (which is highly likely for the application I am using the code for), the code would still work without an error.

Any suggestions?

For those who were lazy and did not click the link, here is the code:

Please Login or Register  to view this content.

Assuming you want the same actions for each changed cell:

Please Login or Register  to view this content.