VBA code that adds comment to cell by userform; runtime error 1004 when left blank

Hi all,

I found some code that allows the user to enter comments into a specific cell through entry on the userform. Now the code works perfectly whenever someone enters something that should be added as a comment. However, when this field is left blank I get a runtime error 1004 when I would want it to refrain from adding a comment. I pasted the code below;

Please Login or Register  to view this content.

In debug mode the line 'rng.AddComment Me.TextBox2.Text' is highlighted. Can anyone help me?

Please Login or Register  to view this content.

Perhaps.

Please Login or Register  to view this content.