About Us

Ayo

Thanks Don.

"Don Guillett" wrote:

To get to the sheet module for this macro, right click sheet tabview
codecopy/paste it
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Rick Rothstein (MVP - VB)" wrote in
message ...
You would use the BeforeDoubleClick event of the worksheet and use the
Target argument (cell double clicked is passed into the event procedure
via this argument) to filter on the cell you are interested in.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, _
Cancel As Boolean)
If Target.Address = "$C$8" Then
'
' Cell C8 was double clicked
' Put your code for it here
'
End If
End Sub

Note: Double clicking a cell usually puts Excel into edit mode within that
cell. If you don't want that to happen, set the Cancel argument to True.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, _
Cancel As Boolean)
If Target.Address = "$C$8" Then
Cancel = True
'
' Cell C8 was double clicked
' Put your code for it here
'
End If
End Sub

Rick

"Ayo" wrote in message
...
I am looking for a function that would perform a set of actions when I
double
click a cell in a worksheet. I know there is something like this in
Access.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Double click to navigate to a cell	Isit Ears	Excel Discussion (Misc queries)	0	November 3rd 06 10:18 AM
Click on graph bar to execute a double-click in a pivot table cell	[email protected]	Charts and Charting in Excel	4	August 3rd 05 01:37 AM
Double click in a Cell	Mike L	Excel Discussion (Misc queries)	1	June 13th 05 03:29 PM
double click a cell and add 1 to that cess	cwwolfdog	Excel Discussion (Misc queries)	3	March 25th 05 01:23 AM
how to copy on double-click the cell value to Clipboard	cyrille	New Users to Excel	2	February 11th 05 11:29 PM

Menu

About Us