text to comments

[keithwins]

I'm trying to convert a bunch of text to comments. I found this snippet online:

Sub TextToComments()
'Updateby20141128
Dim Rng As Range
Dim WorkRng As Range
On Error Resume Next
xTitleId = "TextToComments"
Set WorkRng = Application.Selection
Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8)
For Each Rng In WorkRng
Rng.NoteText Text:=Rng.Value
Next
End Sub

The problem is, it skips a lot of the cells in the range. It skips longer cells, but it's not merely that it's running to some length limit, since it skips some that are shorter than some it doesn't skip. I can't tell any reason it's picking some and not others.

[keithwins]

Also: if I copy/paste, I can take any cell's contents and turn it into the corresponding comment. That is, they fit fine, and there are no weird hidden codes or something that are getting in the way...

[TMS]

Hello and welcome to the forum.

The code works fine for me for a number of cells with "the quick brown fox jumped over the lazy dog". Cells $C$4:$O$19 are selected but only 32 out of the 208 have the text in them. All cells with text had a comment inserted.

Please take a few moments to read the forum rules. In particular:


Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here


You would do well to attach a sample workbook that demonstrates the problem.

To attach a sample workbook: Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[keithwins]

Thanks for the help, and thanks for the schooling. Let me try again. Here's the code snippet:

Please Login or Register  to view this content.

To reiterate: some comments were not created, despite that 1) the lengths of those fields were not necessarily longer than others that were created, and 2)I can create those same comments manually, so it's clearly not a limit of the comment field.

If this gets fixed, I wish ctrl-return line feeds could be copied into comments, they seem to get lost in the process. anyway, thanks for any help! Also, I'm using 2013

[shg]

One way:

Please Login or Register  to view this content.

[keithwins]

With the holidays I didn't get to try this until now. It's cool, I like the vblf piece. I need to play with it, understand it a little better, change it up a little, but it seems pretty great. So I wanted say thanks for now!!! Your careful structuring, both visual and procedural, is helpful to someone just learning the language.

Keith

[shg]

You're welcome.