Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Before Double Click
Private Sub Worksheet_BeforeDoubleClick(ByVal _
Target As Range, Cancel As Boolean) Dim a As String, b, c Cancel = True 'Get out of edit mode a = ActiveCell b = ActiveCell.Address c = Range(b).Column If b < "1" Then Exit Sub Call dble(a) End Sub I looked on http://www.mvps.org/dmcritchie/excel/event.htm#change for ideas and I copied some code and edited it to the above. Basically, I want to contents of the cell that was double clicked on to be taken to sub dble. BUt this should only happen if the cell clicked on was in column A. You can see my attempt at doing this. For some reason it does not work though. When I double click nothin happens. But when I get rid of my code it works fine. Any suggestions... -- Dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change syperlink from single click to double click | Excel Worksheet Functions | |||
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 | |||
CommandBarButton click vs. double click | Excel Programming | |||
Mouse Over Graph, Capture Information on Click(Double Click) | Excel Programming |