Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Include Checkboxes or Controls in email | Excel Discussion (Misc queries) | |||
Record macro to include changes in dropdowns | Excel Programming | |||
Change event for multiple checkboxes | Excel Programming |