It would be much more convenient to have a date table with holiday comment given from a holiday list beneath the date table. Please refer to the attached file and coach me to write the required script. Thanks a lot.
Hi Julian
I don't quite understand what you wanted.
Option 1 : Maybe a VLOOKUP with a helper column?
Option 2 : Or is it you actually wanted an Excel Comment (i.e Right-click cell and click Insert Comment)?
If option 2, do you want the author name to appear in the comment?
See example attached.
Sunny
Hi Sunny,
Not beyond my expectation I would "meet" you again here. As you mentioned about I was looking for a solution to option 2, no need for the author name displayed in the comment and no more blank comment added to those non-holidays. That's it. Thanks for your response so quickly.
Best regards,
Julian
Hi Julian
Attached is the file with the macro. Please follow the instructioins below:
1) You still need to add the helper column with VLOOKUP. It is easier than writing lengthy codes.
2) Select the cells to add the comment (A2:A367).
3) Run the macro.
4) If there is a text in the next column (column B in the example), it will be added as a comment in column A.
5) You can see an example of the outcome in Sheet1
Please note that I have not done much error checking so be careful and not to select the entire column A when running the macro
Hope this helps.
Sunny
Hi Sunny,
Thanks again for your great support. I use date table quite often. Now that with your VBA script it's easy to add the holiday comments on the corresponding cells. I do appreciate it. Happy new year!
Best regards,
Julian
