Include Dropdowns and Checkboxes in Worksheet Change event
 

I am tracking the changes made to cells in the spreadsheet and that is
working. However, there are three active X dropdown lists objects and
numerous check boxes that are not trapped. Each is linked to a cell on the
same sheet in a hidden area that is updated when their values change. I have
code to trap the cells that are changed and execute additional code.

The code in the worksheet change event is;
Private Sub Worksheet_Change(ByVal Target As Range)
Dim tCell As Range
Call ChangeOrder(tCell, tSheet)

In the worksheet module is this code;
Sub ChangeOrder(tCell As Range, tSheet As String)
If tCell.Address = "$AH$63" Then

The address "$AH$63" is on the same sheet in a hidden column.

The change event code is never triggered when the dropdown or checkbox
values are changed.

How can I trigger the change event since the action of checking/unchecking
or selecting an new value do not?

Include Dropdowns and Checkboxes in Worksheet Change event
 

Have a formula which refers to the range where the linked cells are and use
the Calculate event.

Private Sub Worksheet_Calculate()
End Sub

If this post helps click Yes
---------------
Jacob Skaria


"Barry" wrote:

I am tracking the changes made to cells in the spreadsheet and that is
working. However, there are three active X dropdown lists objects and
numerous check boxes that are not trapped. Each is linked to a cell on the
same sheet in a hidden area that is updated when their values change. I have
code to trap the cells that are changed and execute additional code.

The code in the worksheet change event is;
Private Sub Worksheet_Change(ByVal Target As Range)
Dim tCell As Range
Call ChangeOrder(tCell, tSheet)

In the worksheet module is this code;
Sub ChangeOrder(tCell As Range, tSheet As String)
If tCell.Address = "$AH$63" Then

The address "$AH$63" is on the same sheet in a hidden column.

The change event code is never triggered when the dropdown or checkbox
values are changed.

How can I trigger the change event since the action of checking/unchecking
or selecting an new value do not?