Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
trouble using checkbox26_DblClick
I am trying to doubleclick checkbox26 and make value of cell D10 = "N/A" as
well as clear tick in checkbox26. But then if the user later wants to go back and single click checkbox26 I need to clear the "N/A" and have the checkbox operate as normal. Here's what I have: Private Sub CheckBox26_Click() Range("D10").Value = "N/A" End Sub Private Sub CheckBox26_DblClick(ByVal Cancel As ReturnBoolean) Range("D10").Value = "N/A" CheckBox26.Value = False End Sub It works one time but then will not clear D10. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
trouble using checkbox26_DblClick
You can't have both a click and dbl click event for this - the first click of
your double-click will just fire the click event, and you'll never be able to fire the dbl-click event. You can confirm this by having a msgbox for each procedure and you'll see you can only see the msgbox for the click event. Bob Umlas Excel MVP "JL" wrote: I am trying to doubleclick checkbox26 and make value of cell D10 = "N/A" as well as clear tick in checkbox26. But then if the user later wants to go back and single click checkbox26 I need to clear the "N/A" and have the checkbox operate as normal. Here's what I have: Private Sub CheckBox26_Click() Range("D10").Value = "N/A" End Sub Private Sub CheckBox26_DblClick(ByVal Cancel As ReturnBoolean) Range("D10").Value = "N/A" CheckBox26.Value = False End Sub It works one time but then will not clear D10. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
still having trouble | Excel Programming | |||
bar of pie trouble | Charts and Charting in Excel | |||
If than Else Trouble | Excel Worksheet Functions | |||
dim trouble | Excel Discussion (Misc queries) | |||
Im in trouble!!! Please Help!! JS | Excel Discussion (Misc queries) |