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
|