View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Menhennett Paul Menhennett is offline
external usenet poster
 
Posts: 2
Default 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