you would need to do something like this.

The code needs to be placed in the worksheet module


Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Excel.Range,
Cancel As Boolean)
Dim SelCell

' identify which cell has been double clicked
SelCell = Target.Column & ", " & Target.Row

Select Case SelCell
Case "2, 3"
place code here

End Select


End Sub


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/