Solved for some reason the original post info was removed?
Solved for some reason the original post info was removed?
Last edited by SVTF; 10-26-2014 at 10:13 PM.
I am assuming that when you say you are "selecting" you are actually changing the value within a drop down box such as a data validation list. Otherwise you would need to use Worksheet_SelectionChange rather than Worksheet_Change for what you are asking. The reason it is happening twice is because of the range of scope: If Intersect(Target, Range("G:G,I:I")).
The original code accounted for this by requireing both G and I to pass a "True" test prior to executing more code: If Cells(r, "G") = "Yes" And Not IsDate(Cells(r, 9))
By removing the one piece you only need to have the "True" test pass for column G.
To answer your question, based upon what appears to be your procedure, you would need to write a more complex if statement which accounted for the new variables you are introducing or just leave things the way they are and change your procedure back to the initial way. This might do it for you but could easily be prone to problems:
Please Login or Register to view this content.
@SVTF
did this work you?
if it didn't can you upload the file so I can test a few things....thanks
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
@judgeh59 - the suggestion code by @stnkynts created a run time error.
I am at work as soon as I get home I will upload a version - Thanks.
All I did was change the IsDate to IsEmpty. I doubt that is what is causing the error
Figured this part out.
Last edited by SVTF; 10-26-2014 at 10:14 PM.
Anyone able to assist on this in case @judgeh59 does not chime in today.
See post above for tweaks.
Hoping to get this done for tomorrow.
Thanks in advance.
Hello SVTF,
Try this out and let me know it works for you.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
@Leith Ross - No go.
Pop up did not come up when I selected N/A in G
Yes worked.
No worked for < 14 days
No did not work for > 14 days - pop up to change No to Yes did not come up.
I think I figured it out - I modified the original code.
I removed the GoTo Finished from the N/A code section ... seems to be working testing now.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks