LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Include Checkboxes or Controls in email Steve Excel Discussion (Misc queries) 0 June 20th 07 04:21 PM
Record macro to include changes in dropdowns Graeme Excel Programming 4 March 9th 07 09:55 PM
Change event for multiple checkboxes Harald Witmer Excel Programming 2 August 27th 03 12:15 AM


All times are GMT +1. The time now is 07:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"