+ Reply to Thread
Results 1 to 9 of 9

Need to have 2 worksheet selection.change rules in 1 worksheet

  1. #1
    Forum Contributor
    Join Date
    03-04-2014
    Location
    calgary, canada
    MS-Off Ver
    Excel 2013
    Posts
    108

    Need to have 2 worksheet selection.change rules in 1 worksheet

    OK. so attached is a file that when cells in column F and G are clicked in - they auto populate with "NA" and "U". now this is all working fine - EXCEPT for the fact that rows 387-391 need to populate with a "y" and "n" respectively. now i can actually see when i click on the cell - the Y or N populates and then it changes to "NA" and "U". i am attaching the file. all the code is on the sheet "fresh thinking audit".

    if someone could PLEASE see what i have to do to not have two codes run on the same cells i would be so grateful!!!

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by winwall; 03-14-2014 at 01:35 PM.

  2. #2
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Something missing - Not quite working...please see if you can help

    would adding an Exit Sub after you set your Target.Value = "N" mess you up? same for the "Y"
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  3. #3
    Forum Contributor
    Join Date
    03-04-2014
    Location
    calgary, canada
    MS-Off Ver
    Excel 2013
    Posts
    108

    Re: Need to have 2 worksheet selection.change rules in 1 worksheet

    Changed - thanks

  4. #4
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Need to have 2 worksheet selection.change rules in 1 worksheet

    Hi WinWall --- have you tried what I put in Post #2?....

  5. #5
    Forum Contributor
    Join Date
    03-04-2014
    Location
    calgary, canada
    MS-Off Ver
    Excel 2013
    Posts
    108

    Re: Something missing - Not quite working...please see if you can help

    judgeh59 - yes and no go unortunately - just kills everything

  6. #6
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Need to have 2 worksheet selection.change rules in 1 worksheet

    In the Worksheet_SelectionChange()....change the 392 to 387 in the ElseIf (Target.Row > 24) and (Target.Row < 387)....setting it to 392 allow the other code "NA" and "U" to execute....give it a try

  7. #7
    Forum Contributor
    Join Date
    03-04-2014
    Location
    calgary, canada
    MS-Off Ver
    Excel 2013
    Posts
    108

    Re: Need to have 2 worksheet selection.change rules in 1 worksheet

    I will try that thanks

  8. #8
    Forum Contributor
    Join Date
    03-04-2014
    Location
    calgary, canada
    MS-Off Ver
    Excel 2013
    Posts
    108

    Re: Need to have 2 worksheet selection.change rules in 1 worksheet

    and...............Fixed! thanks GUYS!

  9. #9
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Need to have 2 worksheet selection.change rules in 1 worksheet

    glad I could help....Thanks for setting the thread to Solved...If you feel I deserve an increase in my reputations feel free to click on the star in the lower left of the thread. Remember, someday when you help somebody they may add to your rep points, and it could be me...just a thought...

+ 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. Macro is not working as per the offset and hence missing data..
    By kishoremcp in forum Excel Programming / VBA / Macros
    Replies: 31
    Last Post: 06-26-2013, 09:41 AM
  2. Index-Match formula is not working ...whats missing ?
    By raad in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-16-2012, 01:41 PM
  3. Deleting missing references - not working
    By ghh3rd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-20-2012, 04:03 PM
  4. DisplayAlerts = False not working for formula that points to a missing tab
    By iggydfrog in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-17-2012, 05:30 PM
  5. Excel 2007 : Working with Charts and Missing Data
    By faucetguru in forum Excel General
    Replies: 4
    Last Post: 10-07-2010, 08:01 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