If your still in the mood to learn:

Easier would be
TextBox8.Value = ActiveCell.NoteText

works whether there is a comment or not. No IF required.

--
Regards,
Tom Ogilvy



"Toppers" wrote in message
...
FYI, I looked in this NG to see if a similar question had been posted. And
no
surprise really .. it had. so I learned something whilst helping you!

So not all my own work but shows the "power" of this NG.


"excelnut1954" wrote:

I never would have stumbled on this. Thanks big time, Toppers.
I appreciate your help!!