Could someone help me please with a problem inserting multi-line text from the VBE into a comment object on a worksheet.
Please proceed to the text statement below for description of the problem.
With Sheets("Sheet27").Range("A10").AddComment .Text "This is text that should be inserted into a comment. _
Trouble is the vba editor wont accept these "space underscores" _ which i use normally to break up my code for easier reading. What _ is going wrong? I can see its got something to do with the quote marks _ but i need the quote marks for the comment text to work. It doesnt like _ putting text in quotes on each line and using an ampesand (&) to string together."
I get a compile error and the text turns red.
What am i doing wrong and where could i have found the solution for myself without going to the microsoft forum
Many thanks team VBA.
This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread.