Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Trigger Macro on change in cell value | Excel Programming | |||
Cell change to trigger Macro | Excel Programming | |||
Cell value change to trigger macro (worksheet change event?) | Excel Programming | |||
Code to trigger drop down-select event | Excel Programming | |||
Macro trigger? | Excel Programming |