How do I resize an inserted image in a cell?

Hi all,
I have a problem that is driving me crazy. I'm pretty new to VBA/Macros. I have managed to get the macro working to insert a specific jpeg image into the right cell 'W28', however I don't know how to resize the image so that it doesn't cross over the cell borders, which it currently does. The macro is linked to a command button. There will be a few buttons, each one inserting a different signature depending on the user. Once I have the first one sorted, then it will be straight forward to do the others. Here is the code I currently have;

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Can someone please help me on this?

Thanks,
Benn

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

Also,

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.