Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detecting double click
I'm using the following to launch some VBA when a cell is double
clicked. ++++++++ Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim rng As Range Dim MyLastRow As String Set rng =Worksheets("Sheet1").Range("A1").SpecialCells(xlC ellTypeLastCell) MyLastRow = rng.Row rows = "J1:J" & MyLastRow If Not Intersect(Target, Range(rows)) Is Nothing Then Cancel = True ********* Code here End If End Sub ++++++++++ Howver, I'd like to change that so any cell in the range S2 to CD5972 achieves the same result. Is that possible? Thanks - Kirk |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change syperlink from single click to double click | Excel Worksheet Functions | |||
Detecting Double Entries | Excel Programming | |||
userform label double-click goes to click event | Excel Programming | |||
Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel | |||
Mouse Over Graph, Capture Information on Click(Double Click) | Excel Programming |