PC Review


Reply
Thread Tools Rate Thread

beforerightclick and selection change issue

 
 
DennisB
Guest
Posts: n/a
 
      28th Oct 2008
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
BeforeRightClick event vs. Selection Change DennisB Microsoft Excel Programming 3 7th Dec 2011 08:07 PM
BeforeRightClick gk Microsoft Excel Worksheet Functions 4 24th Oct 2009 02:54 PM
Table selection contrast issue - any way to change? dB333 Microsoft Access 1 28th Nov 2008 03:27 AM
BeforeRightClick Rob Microsoft Excel Programming 0 29th Jan 2008 02:22 PM
Excel VBA - Range(Selection, Selection.End(xlDown)).Name issue. jonH Microsoft Excel Programming 3 7th Jun 2004 09:13 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:02 AM.