Thanks for your help, but for some reason your solution doesn't work for me.
No need to bother any further though as I found a way to achieve what I wanted without using the IsFormula function.
I just use the VBA code to enter the required message, depending on which pasting method was chosen, rather than using the UDF to check for presence of values or linked formula.
Can't believe I didn't think of that in the first place.