Hello,
I am trying to learn how to combine two set of Private Sub on a same worksheet.
Here is my codes:
It compiles but has no result from either range entry for EntryDate or RecvDate.
Please Login or Register to view this content.
What is my problem? All help and suggestion are appreciated. Thank you
Last edited by AliGW; 03-24-2024 at 02:45 AM. Reason: Code tags added - please review the forum guidelines.
pls try this code
Please Login or Register to view this content.
Last edited by wk9128; 03-24-2024 at 03:00 AM.
Hello wk9128,
Thank you for your help. It works like a charm. Do mind to elaborate why my codes did not work so that I can understand ? Thanks
@MeMikeExcel You're Welcome. Glad to help . Thank You for the feedback.
If you finally get a solution please mark your thread as SOLVED:
- Click Thread Tools above your first post,you will see the word PREFIX on the upper left, press the button to select [SOLVED] select "Mark your thread as Solved".
- you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help
was given. By doing so you can add to the reputation(s) of those who helped.
In your code, you first check for the condition that the Target cell (the cell that was changed, causing this sub to run) is in column A, which you have named EntryDate. If this condition is not True, then your code does an Exit Sub. Therefore the rest of the code is never run. It never gets to the check to see if Target is in column AD (RecvDate).Originally Posted by MeMikeExcel
However, it should work when Target is in column A.
...and:
Please Login or Register to view this content.
NOTE: As the original poster/owner, only you can mark your thread as SOLVED (Thread Tools above Post #1).
You can say "Thanks" in your thread to everyone who offered to help you.
You can also reward them by clicking * "Add Reputation" under their username on the left.
With Regards, MikeVol.
This is the best practice, although declaring EntryDate without a type, or not declaring it at all, will default to Variant. That is not what's causing that code to fail.
I know that this is not an error for a procedure failure. But, as you yourself said: for best practice. Good luck!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks