I'm looking to create a macro so that when you type E into a cell it automatically opens up a comment box for editing with the some pre-written text in the comment box all in bold like:
Event:
Date:
Location:
I modified a macro which can do this in cell a1 to give some ideas of format I'm looking for:
The above code really only shows the format of the comment box I'm looking for. The way the macro is to work is best demonstrated by a macro I found on another forum which actually opens up the comment to be edited and the comment is deleted when the cell value is deleted. I'm looking for a combination of the two but I can't seem to isolate the code I'm looking for also I only want the macro to run when the letter 'e' is written in the cell.
Thanks
Bookmarks