I want to create a macro in VB to automatically pop-up message once the excel file is open based on some criteria.
Attach is the sample excel workbook i'm working on. I want the macro to pop-up msg to alert user on the target date, etc., automatically once the workbook is open.
Criteria e.g. if the actual feedback is blank, if the target feedback date is greater than today's date, then msg "Exceed target feedback, Pls action accordingly".
I've created the scripts but it doesn't seems to work.
Fyi, i'm using MS Excel 2003. Your advise is highly appreciated.
Please Login or Register to view this content.