Thank you very much for your help!

Emma

Trevor Shuttleworth wrote:
Emma

I think you will have to use a macro. Assuming the keyboard is in Sheet 1,
the Sheet 1 Class Module needs the following Selection Change code:

' Sheet 1 Class Module
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.EnableEvents = False
Range("A2") = Target.Address(False, False)
Application.EnableEvents = True
End Sub

Whenever a cell is selected, its address will be put into cell A2

Regards

Trevor

I have drawn a keyboard in excel (B1 is note C, C2 is note D etc). The
user
[quoted text clipped - 8 lines]

Emma

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200603/1