+ Reply to Thread
Results 1 to 2 of 2

Double click event

  1. #1
    Registered User
    Join Date
    06-11-2009
    Location
    Ft Lauderdale, USA
    MS-Off Ver
    Excel 2003
    Posts
    7

    Double click event

    I am looking for a code that by double clicking the cell A1 of a worksheet, a label pops up. I really need this code. Thanks.

  2. #2
    Valued Forum Contributor
    Join Date
    11-11-2008
    Location
    Euro
    MS-Off Ver
    2007, 2010
    Posts
    470

    Re: Double click event

    using Worksheet_BeforeDoubleClick even of the sheetcode, like this:

    PHP Code: 
    Private Sub Worksheet_BeforeDoubleClick(ByVal Target As RangeCancel As Boolean)
        If 
    Not Intersect(TargetRange("A1")) Is Nothing Then
          MsgBox 
    ("A1 doulbe click")

          
    ''put your code here

        End 
    If
        
    End Sub 

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1