Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Before_Double_Click Event
I have some code that toggles between two values (Yes/No) when the user
double clicks the cell. The problem is, it only works once, then you have to leave the cell and come back for it to work again. Is there a programmatic way to reset the cell to the predouble click state so it will accept this event again. I have tried activating another cell and then reactivating this cell but it does no good. And another question. Why are there so few events? No click events no mouse up,down, move and cells are not objects. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Before_Double_Click Event
Remember to Cancel (editting) in the flip-flop:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Intersect(Target, Range("A1")) Is Nothing Then Exit Sub If Target.Value = "yes" Then Target.Value = "no" Cancel = True Exit Sub End If Target = "yes" Cancel = True End Sub -- Gary''s Student - gsnu200907 "Paul Menhennett" wrote: I have some code that toggles between two values (Yes/No) when the user double clicks the cell. The problem is, it only works once, then you have to leave the cell and come back for it to work again. Is there a programmatic way to reset the cell to the predouble click state so it will accept this event again. I have tried activating another cell and then reactivating this cell but it does no good. And another question. Why are there so few events? No click events no mouse up,down, move and cells are not objects. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Before_Double_Click Event
I've never seen that happen.
Maybe you're not doubleclicking fast enough or maybe even too fast. This worked for me: Option Explicit Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, _ Cancel As Boolean) MsgBox "hi" Cancel = True 'stop the editing in cell End Sub If this doesn't help, you may want to share your procedure. Paul Menhennett wrote: I have some code that toggles between two values (Yes/No) when the user double clicks the cell. The problem is, it only works once, then you have to leave the cell and come back for it to work again. Is there a programmatic way to reset the cell to the predouble click state so it will accept this event again. I have tried activating another cell and then reactivating this cell but it does no good. And another question. Why are there so few events? No click events no mouse up,down, move and cells are not objects. Thanks -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Before_Double_Click Event
Thank you.
Solved my problem. "Gary''s Student" wrote: Remember to Cancel (editting) in the flip-flop: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Intersect(Target, Range("A1")) Is Nothing Then Exit Sub If Target.Value = "yes" Then Target.Value = "no" Cancel = True Exit Sub End If Target = "yes" Cancel = True End Sub -- Gary''s Student - gsnu200907 "Paul Menhennett" wrote: I have some code that toggles between two values (Yes/No) when the user double clicks the cell. The problem is, it only works once, then you have to leave the cell and come back for it to work again. Is there a programmatic way to reset the cell to the predouble click state so it will accept this event again. I have tried activating another cell and then reactivating this cell but it does no good. And another question. Why are there so few events? No click events no mouse up,down, move and cells are not objects. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
apply cell change event to single column - WorksheetChange Event | Excel Programming | |||
Click event on menu item is lost after first time firing of the event | Excel Programming | |||
How to trap delete row event and hide column event? | Excel Programming | |||
user form-on open event? keydown event? | Excel Programming | |||
OnTime event not firing in Workbook_Open event procedure | Excel Programming |