Hi I cant work out which worksheet function to use to
spark off some code if the button F6 is pressed.

I know it is something like -

Sub Worksheet_Whats this??()

If Application.SendKeys(vbKeyF6) Then
MsgBox ("you pressed F6")
End
End If

End Sub

Thanks
Jim