+ Reply to Thread
Results 1 to 3 of 3

Worksheet Change if Column is not equal to:

  1. #1
    Registered User
    Join Date
    08-14-2014
    Location
    Connecticut, US
    MS-Off Ver
    2010
    Posts
    5

    Worksheet Change if Column is not equal to:

    Hello - Hoping someone here can help me with this one.

    I have a spreadsheet that is used as a Time-Off requester (i.e. the end users request time off via a user form. The data from the user form is sent to Sheet1(Reporting) and later by a macro is copied from the Reporting sheet to Sheet7(Log). The Reporting sheet is then cleared (for the next use of the macro).

    The Log sheet keeps populating via the macro (it’s a running list of pending time off requests). Column J of the Log has the current status of the request – either Yes, No, or Pending, pending being the default.

    What I need is (I think) a worksheet change macro for the Log that will run whenever column J is changed, but not when it is Pending. So when the column is changed to anything other than pending.

    The macro I'm hoping to run on the change (I've been trying by call) will copy the active cells row on the Log & send it to a transfer tab Sheet13(AETrans), which then sends an email, etc.

    Any help would be greatly appreciated.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Worksheet Change if Column is not equal to:

    Hi,

    The usual way is to use code like the following

    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    08-14-2014
    Location
    Connecticut, US
    MS-Off Ver
    2010
    Posts
    5

    Re: Worksheet Change if Column is not equal to:

    Wow that seems to easy! It looks like I had another macro turning off events & not turning them on (so nothing was working). It is working now with your the fix and your code. Sometimes simpler is better

    Thanks Richard!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Worksheet change event with multiple column cell value change
    By borgyang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-29-2015, 11:53 AM
  2. If range value change, active cell equal date and time of change.
    By kmakjop in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-31-2015, 02:43 PM
  3. Replies: 1
    Last Post: 11-24-2013, 01:51 AM
  4. [SOLVED] Create new Worksheet for each change in Column B
    By philwilliams80 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-10-2013, 02:39 PM
  5. Worksheet change VBA to set cell value, same row, different column ?
    By NikonMan in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-07-2013, 10:39 PM
  6. Trigger column value changes in worksheet WS2 based on value change in WS1 column
    By sunny89 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-11-2010, 12:04 PM
  7. Function to set a column equal to a value in an other worksheet
    By tmani in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-03-2007, 10:49 AM

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