Run macro on double click only

Let's say I have an item that I want to select with one click, and run a macro with a second click. How can this be done?

Use the double-click event

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, _
Cancel As Boolean)
... your code here
End Sub

This is worksheet event code, which means that it needs to be
placed in the appropriate worksheet code module, not a standard
code module. To do this, right-click on the sheet tab, select
the View Code option from the menu, and paste the code in.


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"famdamly" <famdamly.23vkwm_1141022400.6677@excelforum-nospam.com> wrote in
message news:famdamly.23vkwm_1141022400.6677@excelforum-nospam.com...
>
> Let's say I have an item that I want to select with one click, and run a
> macro with a second click. How can this be done?
>
>
> --
> famdamly
> ------------------------------------------------------------------------
> famdamly's Profile:
http://www.excelforum.com/member.php...o&userid=29382
> View this thread: http://www.excelforum.com/showthread...hreadid=516789
>

I think Bob meant:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, _
Cancel As Boolean)

Cancel = true

'your code here

End sub


If you have "tools|options|edit tab|edit directly in cell" checked, then the
"Cancel = true" tells excel to not edit the cell.

Bob Phillips wrote:
>
> Use the double-click event
>
> Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, _
> Cancel As Boolean)
> ... your code here
> End Sub
>
> This is worksheet event code, which means that it needs to be
> placed in the appropriate worksheet code module, not a standard
> code module. To do this, right-click on the sheet tab, select
> the View Code option from the menu, and paste the code in.
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "famdamly" <famdamly.23vkwm_1141022400.6677@excelforum-nospam.com> wrote in
> message news:famdamly.23vkwm_1141022400.6677@excelforum-nospam.com...
> >
> > Let's say I have an item that I want to select with one click, and run a
> > macro with a second click. How can this be done?
> >
> >
> > --
> > famdamly
> > ------------------------------------------------------------------------
> > famdamly's Profile:
> http://www.excelforum.com/member.php...o&userid=29382
> > View this thread: http://www.excelforum.com/showthread...hreadid=516789
> >

--

Dave Peterson