Easy Trigger Question

jasgot

New Member
Joined
Jul 16, 2002
Messages
22
This works great when I click in the cell and change the value:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Address = Range("VB_Trigger").Address Then


How can I trigger this code if "VB_Trigger" is a self change formula from other cells?

ie; VB_Trigger is =D10+D11 so it changes on it's own and my trigger doesn't get tripped.....
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

gnaga

Well-known Member
Joined
Jul 9, 2002
Messages
680
Office Version
  1. 365
  2. 2016
  3. 2013
Platform
  1. Windows
You can declare a global variable and store the content of VB_Trigger while opening the workbook. Then every cell change compare with the old content. if there is a change in the content then execute your code. finally store the current content of VB_Trigger

GNaga
 

Watch MrExcel Video

Forum statistics

Threads
1,118,540
Messages
5,572,794
Members
412,483
Latest member
deezina07
Top