Results 1 to 5 of 5

macro to trigger Cond Formatting when just CLICK on any cell in a range

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-08-2019
    Location
    Singapore
    MS-Off Ver
    2016
    Posts
    326

    macro to trigger Cond Formatting when just CLICK on any cell in a range

    Hi

    i'm trying to write a macro that will trigger the Conditional Formatting when I just CLICK on any cell within the specified range, but it doesn't seem to be working. Can anyone who knows where I'm wrong/inadequate point me in the right way here..?


    Private Sub Worksheet_Change(ByVal Target As Range)
    
       If Selection.Count = 1 Then
            If Not Intersect(Target, Range("A2:Q1000")) Is Nothing Then
            Range("A2:Q1000").FormatConditions(1).StopIfTrue = True
            ActiveSheet.Calculate
            End If
       End If
    
    End Sub

    cheers
    Stewart
    Last edited by Pepe Le Mokko; 03-20-2020 at 05:53 AM. Reason: Code tags

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Adjust a code from cell range trigger to button trigger
    By ld2x07 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-01-2014, 10:02 AM
  2. [SOLVED] Double click cell to trigger a Copy Macro
    By mjfox52610 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-10-2013, 02:15 PM
  3. [SOLVED] Trigger macro on click
    By ikavellari in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-05-2013, 08:12 AM
  4. [SOLVED] Cond. formatting a column/Range, highlight cell in column/range if equal to specific text
    By DFrank231 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-19-2013, 03:35 PM
  5. Can't get command button click to trigger cell population
    By clcs in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-25-2010, 01:43 AM
  6. click into a cell to trigger an event
    By DDR2 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-01-2008, 09:48 AM
  7. [SOLVED] Is it possible to click in a cell and trigger a macro?
    By serdar in forum Excel General
    Replies: 9
    Last Post: 10-17-2005, 09:05 AM

Tags for this Thread

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