left click on cell run macro

[bam12]

is it possible to click on cell in spreadsheet and it will run a macro

 

[Oaktree]

Sure. Have a look at the SelectionChange event.

e.g. in the appropriate sheet module, put:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$A$5" Then MsgBox "You have selected A5"
End Sub

 

[shajueasow]

Directly clicking on a cell to run your own macro? Don't think so. But there is a way around.
Click on a cell and press SHIFT and click on EDIT and select COPY PICTURE and then select the concerned cell of your's and press SHIFT and click on EDIT and select PASTE PICTURE. Now you can assign a macro to it.
HTH

 

[bam12]

it is possible

i have a sheet i downloaded and it works there, but i can figure out the code so i can implement it into my sheet

 

[shajueasow]

You can either use Oaktree's method and it just need the selection to be on the desired cell. Either by clicking on the cell or selecting it with arrow keys.
In the other way you are actually not clicking ON the CELL but only on an object placed over the cell.

 

[lenze]

There are two options. Oaktree's SelectionChange Event or the Worksheet_BeforeDoubleClick event.

See http://www.cpearson.com/excel/events.htm for some good background info on Events.

Also check the articles on MrExcel.com here
http://www.mrexcel.com/articles.shtml

lenze

 

[bam12]

thanks

Thanks
will check them out