Results 1 to 3 of 3

Trouble with Worksheet Change when Target Cell Changed by Formula

Threaded View

phelbin Trouble with Worksheet Change... 10-11-2016, 01:48 PM
MrShorty Re: Trouble with Worksheet... 10-11-2016, 02:14 PM
phelbin Re: Trouble with Worksheet... 10-11-2016, 04:00 PM
  1. #1
    Forum Contributor
    Join Date
    02-18-2014
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2013
    Posts
    197

    Trouble with Worksheet Change when Target Cell Changed by Formula

    I have a list of checkboxes that have referring cells (TRUE/FALSE) in columns X and Y. In cell Z3, I'm counting the number of TRUE values in columns X and Y. If it goes above 9, then:

            If Range("Z3").Value = False Then
                MsgBox "ERROR: You may only select 9 Contact Tags"
            End If

    My problem is that cell Z3 change is changed by referring cells, which are changed by the checkboxes. I've tried a half dozen different ways to get the Worksheet_Change or Worksheet_Calculate events to trigger, but no luck.

    Any ideas?
    Attached Files Attached Files
    Last edited by phelbin; 10-11-2016 at 01:48 PM. Reason: Forgot attachment

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Worksheet Change - need to ignore target cell in results
    By zookeepertx in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-25-2015, 06:32 PM
  2. [SOLVED] Why other worksheets changed when I change the value on in the cell on one worksheet?
    By ypurcaro in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 10-16-2013, 02:05 PM
  3. Replies: 5
    Last Post: 09-07-2013, 03:57 AM
  4. get cell value from worksheet change target
    By vangxbg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-06-2013, 06:07 PM
  5. Replies: 5
    Last Post: 01-22-2013, 11:38 AM
  6. Worksheet Change: Formula in Target Range
    By rhudgins in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-29-2010, 02:46 PM
  7. Change the formula of a target cell in a self-defined worksheet function
    By mxcaocao in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-29-2008, 02:50 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1