Trigger Macro on Cell select
 

Ok, easy question for you guys... I've programed a script in the VB
editor, and need it triggered everytime a certain cell gets activated.
any suggestions?

Trigger Macro on Cell select
 

Open Workbook
Press Alt+F11
On the Left side of the screen should be a VBAProject(YourWorkbook)
Double-Click to expand
Double-Click the Sheet with the cell of interest
At the top of the main screen are 2 comboboxes,
in the left one select "Worksheet"
in the right one select "Change"
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Should
appear
Add this before the "end sub":
If Not Target = Range("A1") Then Exit Sub 'Change A1 to your
"certain cell"
'Your Code

HTH

Die_Another_Day

wrote:
Ok, easy question for you guys... I've programed a script in the VB
editor, and need it triggered everytime a certain cell gets activated.
any suggestions?