Don't ignore Ken Johnson's post. That's the code I used to create the
conditional comment. I've since tried recording a macro while creating and
formatting a comment, then copied that code into my macro but it keeps coming
up with errors. I don't know enough about vbasic I'm afraid.

"mudraker" wrote:


Ken

can you post the code that creates the Comment box


--
mudraker
------------------------------------------------------------------------
mudraker's Profile: http://www.excelforum.com/member.php...fo&userid=2473
View this thread: http://www.excelforum.com/showthread...hreadid=400311