Kris,

Use the BeforeDoubleClick event in the code module for the appropriate
sheet. Put the following code in the Sheet's code module:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, _
Cancel As Boolean)
Select Case Target.Address(False, False)
Case "A1"
' code for A1
Cancel = True
Case "B2"
' code for B2
Cancel = True
Case "C3"
' code for C3
Cancel = True
Case Else
End Select
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"kris" wrote in message
...
How can I program an event, such as a double click on a
particular cell in a worksheet, to excute VBA code. Click
events on different cells in that worksheet would trigger
different VBA functions.
Thanks for any help.