Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB CODE for double click?
DEAR ALL
Can someone suggest me a VB code to be placed in sheet event BeforeDoubleClick so that any cell I double click in colum A, it calls for macro 'insert_tow'. If i get this code, I am done for the day as the program is complete with this. Pls help. brgds/captgnvr |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB CODE for double click?
See if this will work....
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Selection.Column = 1 Then insert_tow ' call your other macro End If End Sub Mark Ivey "CAPTGNVR" wrote in message ... DEAR ALL Can someone suggest me a VB code to be placed in sheet event BeforeDoubleClick so that any cell I double click in colum A, it calls for macro 'insert_tow'. If i get this code, I am done for the day as the program is complete with this. Pls help. brgds/captgnvr |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB CODE for double click?
Hi,
I wasn't sure if insert_tow was a typo and you want to insert a row so this can do either just use the line you want Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Target.Column = 1 Then insert_tow 'Target.EntireRow.Insert End If End Sub Sub insert_tow() MsgBox "insert_tow running" End Sub Mike "CAPTGNVR" wrote: DEAR ALL Can someone suggest me a VB code to be placed in sheet event BeforeDoubleClick so that any cell I double click in colum A, it calls for macro 'insert_tow'. If i get this code, I am done for the day as the program is complete with this. Pls help. brgds/captgnvr |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB CODE for double click?
if target.column<1 then exit sub
target.entirerow.insert -- Don Guillett Microsoft MVP Excel SalesAid Software "CAPTGNVR" wrote in message ... DEAR ALL Can someone suggest me a VB code to be placed in sheet event BeforeDoubleClick so that any cell I double click in colum A, it calls for macro 'insert_tow'. If i get this code, I am done for the day as the program is complete with this. Pls help. brgds/captgnvr |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB CODE for double click?
YES MARK--another BINGO.
your code works fine as I want and todays job is a good satisfaction of learning a lot. thank you and brgds/captgnvr "Mark Ivey" wrote: See if this will work.... Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Selection.Column = 1 Then insert_tow ' call your other macro End If End Sub Mark Ivey "CAPTGNVR" wrote in message ... DEAR ALL Can someone suggest me a VB code to be placed in sheet event BeforeDoubleClick so that any cell I double click in colum A, it calls for macro 'insert_tow'. If i get this code, I am done for the day as the program is complete with this. Pls help. brgds/captgnvr |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I code a cell to display the current date on double-click? | Excel Programming | |||
How to trigger code in Excel add-in after double-click or right-cl | Excel Programming | |||
Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel | |||
Q. How do I code a column to insert current date, when I double-click? | Excel Programming | |||
Mouse Over Graph, Capture Information on Click(Double Click) | Excel Programming |