Worksheet_Change Event not working

[dgibney]

I have two columns ("E" and "G") of data validation list pull-down menus in a worksheet. When the user changes a cell (via list item selection) in either of these two columns it changes a cell in another column ("B") in the same worksheet. The cells in this single column reference the two columns, such as "B3 = $E$3" and "B4 = $G$4", etc. I want the changing of the cells in the single column to toggle a named cell ("SelectionChanged") as True or False. I'm using this macro:

Please Login or Register  to view this content.

The macro doesn't work, but it does if I manually edit any cell in column "B". What must I do to make this macro work? Also, I am open to suggestions to a macro that directly triggers True/False from the changing of lists in "E" and "G". Thanks for your input. David

[Arkadi]

A new formula result does not trigger the worksheet change event.

[dgibney]

Yes, I've read that but still need to find a way to get "SelectionChanged" to toggle True or False. Any suggestions? Thanks Arkadi. David

[Arkadi]

David, you could base it on changes in the E or G cell instead? Maybe

Please Login or Register  to view this content.

there is also a worksheet calculation event, but it has no "target" as far as I remember so it is hard to use it for what you want.