Hello,

sometimes, I have to comment some cells which are formatted as DATE (short). This comment has to comply with two requirements:

- the comment should be directly in the cell (and not in the yellow "sticky note")
- for calculation reasons, I don't want to loose the formatting of the cell content being a DATE

My current work around:

- Format cells
- Number
- Date (DD.MM.YYYY)
- Custom
- "appending" the comment, e.g. "deadline"

My intention is, to have a tool for this which is also easy applicable for colleagues:
- I click on the cell the I intend to insert the comment
- then, I click on a button anywhere on the sheet
- a dialog box appears where I can write in my comment, e.g. "deadline"
- clicking OK of this dialog box leads to the intended custom formatting of the chosen cell (running a macro)

Is something possible?

Regards

Florian