Hi,

It is a bit difficult to give you very precise answers, without looking at your code ...
However, a couple of comments ...

1. You could have what you call the "comments process" triggered by the date selected on the calendar form ... and not by what is triggering it right now ...
2. The Calendar default date is a variable which can be set to equal the current activecell of your worksheet ...

HTH
Carim