Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Doubleclick
Is it possible to use two DoubleClick's same programme?
Probably, not. Is there a work around? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Doubleclick
Something like this?... Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, _ Cancel As Boolean) If Target.Column = 2 Then Cancel = True MsgBox "Add more salt" ElseIf Target.Column = 5 Then Cancel = True MsgBox "Pour on the Ketchup" End If End Sub -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "smandula" wrote in message Is it possible to use two DoubleClick's same programme? Probably, not. Is there a work around? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Doubleclick
Thanks Jim, Your Solution works. However, the target value resides in the same column, from which a Draw Line goes both left and right up the rows moving one column over each time. I went back to the Command Button setup, which means Click the cell, Click the Button. DoubleClick would have eliminated one step. However, exercise is Good. With Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Doubleclick
On Oct 11, 8:42 pm, smandula wrote:
Thanks Jim, Your Solution works. However, the target value resides in the same column, from which a Draw Line goes both left and right up the rows moving one column over each time. I went back to the Command Button setup, which means Click the cell, Click the Button. DoubleClick would have eliminated one step. However, exercise is Good. With Thanks Not sure what your criteria is, but you could so something like: If Target.Text = "Fred" Then MsgBox "Flinstone" ElseIf Target.Text = "Barney" Then MsgBox "Rubble" End If Of course, if you have many conditions, a Case statement would be preferred. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
doubleclick mrehod | Excel Programming | |||
ON.DOUBLECLICK function | Excel Discussion (Misc queries) | |||
DoubleClick Method? | Excel Programming | |||
doubleclick | Excel Worksheet Functions | |||
Before DoubleClick | Excel Programming |