View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
barry barry is offline
external usenet poster
 
Posts: 116
Default 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?