This is a sample of my Loan Excel. Column A=Bank, B is Issue date. C is End Date. D is amount. E is remark.Because we have to do quite a lot of paper work whenever we have to repay the loan. Hence i created a Action done column in F.
Basically, what i want is whenever someone open and close the file, and if there is a date=today in Column D. It will pop a message and show its respective Remark in E. UNLESS the word "done" is already in its respective column F.
Like this
Please Login or Register to view this content.
Last edited by mike7952; 04-04-2017 at 03:06 AM.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
Try in attached file
Message string is built up line by line and reported at the end
Condition amended to <= today's date
Validation added to column F to ensure word "Done" is always used
VBA is in the workbook Module.
Please Login or Register to view this content.
Last edited by kev_; 04-04-2017 at 03:17 AM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
If you want to prevent the file from closing until the sheet is amended
Put this line at the TOP of the module before any macros (retain the last value in the variable)
and add a line to the before close macro:Please Login or Register to view this content.
Please Login or Register to view this content.
Hey, its good. But how do i make the msgbox reference to the Remark Column (E) instead of juz the column number?
Replace one line:
withPlease Login or Register to view this content.
Please Login or Register to view this content.
Thanks!!!!Originally Posted by kev_
Replace one line:
withPlease Login or Register to view this content.
Please Login or Register to view this content.
You are welcome.
Thanks for marking the thread as solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks