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.
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.
using Worksheet_BeforeDoubleClick even of the sheetcode, like this:
PHP Code:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Not Intersect(Target, Range("A1")) Is Nothing Then
MsgBox ("A1 doulbe click")
''put your code here
End If
End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks