Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with "Doubleclick event"
Hi all, as a dabbler and not a programmer i have been experimenting with
trying to double click on a cell which is a named range and have it take me to another worksheet but only if the cell value is more than 0. It must take me to another sub were i will have a filter code to show the parts relevant to that field. Any help would be greatly appreciated. -- Les |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with "Doubleclick event"
Hi,
In the code module of the sheet, use the sub BeforeDoubleClick to capture that event; something like: '---------------------------------------------------------------------------- Private Sub Worksheet_BeforeDoubleClick( _ ByVal Target As Range, Cancel As Boolean) Dim oldEnableEvents as boolean '''prevent other event to fire while processing oldEnableEvents= application.enabledEvents application.enabledEvents=false '''' YOU CODE OR CALL HERE '''reset EnableEvents application.enabledEvents=oldEnableEvents ''' prevent user-edit of the cell Cancel = True End Sub '---------------------------------------------------------------------------- -- Regards, Sébastien <http://www.ondemandanalysis.com "Les" wrote: Hi all, as a dabbler and not a programmer i have been experimenting with trying to double click on a cell which is a named range and have it take me to another worksheet but only if the cell value is more than 0. It must take me to another sub were i will have a filter code to show the parts relevant to that field. Any help would be greatly appreciated. -- Les |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with "Doubleclick event"
and by the way, the section of your code would test the cell for values
greater than 0: '''' YOU CODE OR CALL HERE If Val(Target.cells(1))0 then ''' <code end if -- Regards, Sébastien <http://www.ondemandanalysis.com "sebastienm" wrote: Hi, In the code module of the sheet, use the sub BeforeDoubleClick to capture that event; something like: '---------------------------------------------------------------------------- Private Sub Worksheet_BeforeDoubleClick( _ ByVal Target As Range, Cancel As Boolean) Dim oldEnableEvents as boolean '''prevent other event to fire while processing oldEnableEvents= application.enabledEvents application.enabledEvents=false '''' YOU CODE OR CALL HERE '''reset EnableEvents application.enabledEvents=oldEnableEvents ''' prevent user-edit of the cell Cancel = True End Sub '---------------------------------------------------------------------------- -- Regards, Sébastien <http://www.ondemandanalysis.com "Les" wrote: Hi all, as a dabbler and not a programmer i have been experimenting with trying to double click on a cell which is a named range and have it take me to another worksheet but only if the cell value is more than 0. It must take me to another sub were i will have a filter code to show the parts relevant to that field. Any help would be greatly appreciated. -- Les |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ... | Excel Programming |