Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
beforerightclick and selection change issue
I have a report where I use the selection change worksheet event to display a
form1. I want to use the beforerightclick event to display another form, form2 and not display the form from the selection change. I have a workaround but form1 quickly displays and then unloads in a flicker. I don't want to see this flicker. Here is my code: Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean) 'unload form1 which is displayed on the selection change event Unload frmAcctDrillDown Cancel = True 'load form2 Load frmNotes frmNotes.Show End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
BeforeRightClick | Excel Worksheet Functions | |||
BeforeRightClick | Excel Programming | |||
Using BeforeRightClick in addins | Excel Programming | |||
Using BeforeRightClick in addins | Excel Programming | |||
Excel VBA - Range(Selection, Selection.End(xlDown)).Name issue. | Excel Programming |