ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   TRUE/FALSE BOX not activating a WS change (https://www.excelbanter.com/excel-discussion-misc-queries/183435-true-false-box-not-activating-ws-change.html)

jase

TRUE/FALSE BOX not activating a WS change
 
I have a code that is triggered by a worksheet change in a target area. I
have true/false check boxes to make my changes but the worksheet is not being
triggered from them. Any idea how I can manipulate this?

Bob Phillips

TRUE/FALSE BOX not activating a WS change
 
The checkboxes won't trigger a change event, that is triggered by a cell
change. Assign a macro to the checkbox that does what you require.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Jase" wrote in message
...
I have a code that is triggered by a worksheet change in a target area. I
have true/false check boxes to make my changes but the worksheet is not
being
triggered from them. Any idea how I can manipulate this?





All times are GMT +1. The time now is 05:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com