Results 1 to 10 of 11

Thread: Left and Right Mouse Click Event

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #4
    Junior Member
    Join Date
    Nov 2012
    Posts
    1
    Rep Power
    0
    Quote Originally Posted by Excel Fox View Post
    Yes you can using

    Code:
    Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
        
        Cancel = True
        MsgBox "Double-Clicked"
        
    End Sub
    OR
    Code:
    Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
    
        Cancel = True
        MsgBox "Right-Clicked"
        
    End Sub


    beg pardon, 1 year later , am looking for the left click version for events. this would be for a mouse left click only, so can tab into cell without the event taking place. thanks.
    Last edited by EQX; 11-24-2012 at 04:59 AM.

Similar Threads

  1. Set Adjust A Button Top Left Position Programmatically
    By jeffrey159 in forum Access Help
    Replies: 5
    Last Post: 02-02-2013, 06:24 PM
  2. Sort data sheet by right_click of mouse
    By Rasm in forum Excel and VBA Tips and Tricks
    Replies: 3
    Last Post: 12-08-2012, 07:34 PM
  3. Replies: 2
    Last Post: 02-29-2012, 08:24 PM
  4. Replies: 3
    Last Post: 12-07-2011, 09:59 PM
  5. Replies: 2
    Last Post: 11-08-2011, 08:52 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •