run excel macro on cell select or event to do same 1

[DavidAWH]

Hi
Does any one know if it is possible to run an excel macro when a user clicks a certain cell or is there an event ( maybe sheet1_click(row,column) )
thanks in advanced
DavidAWH

 

[bryanbayfield]

Yep, sure is.

Go to the worksheet module in VBA (for whatever sheet you're interested in creating code for). Use the drop down menus to get the Selection_Change event of the worksheet.

Option Explicit
Dim cll_rng As Range
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Set cll_rng = Range("a1", Range("d9"))
If Not Intersect(cll_rng, Target) Is Nothing Then
     ' code to execute
     End If
Set cll_rng = Nothing
End Sub

Here I've used a rectangular range of a1 to d9 as containing the cells which activate the code, but change to your requirements (obviously!)