how can I start a macro with a mouse click

[petarr]

Thats it... how can I start a macro with a mouse click?

 

[macropod]

What application?

Cheers
Paul Edstein
[MS MVP - Word]

 

[SkipVought]

Hi,

Put a button in you application that calls the macro on the click event?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[petarr]

ops sry... its Excel 2007

I'd like to have an option button so when I select the option button, I'd like to run the macro with any click, anywhere

For exemple I select Option button 1 and if I select a cell in the range A120, the macro is eecuted

I hope I was clear

 

[petarr]

For eemple any cell i select in the range becomes green and a text appears

 

[SkipVought]

You need at least two Option Buttons.

Then use the Worksheet_SelectionChange event to run your macro.

What code do you have so far?

Have you placed a Option Buttons on your sheet?

Are you useing Control Toolbox or Forms controls?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[petarr]

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("B6:O11")) Is Nothing Then
...
I use option buttons