LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default What are the character codes of a carriage return entered in a comment?

I need to rewrite a filter that takes regular CR-LF (Chr(13)Chr(10)
characters out of all the comments on a page but leaves carriage returns
entered in typing in the comment.

The latter are apparently NOT the regular vbCRLF pair of characters. I have
written a filter that distinguishes between the two types of carriage
returns by using the vbCRLF constant in a SEARCH worksheet function, but I
also need to detect whether any "soft returns" are included in a comment and
count them. This is necessary in order to know how to size the comment after
filtering it. (The procedure both resizes and changes the shape of the
comment.)

So my question is, what are the characters entered into a comment when one
(manually) types a carriage return into a comment using Insert Comment.

The vbCRLF comments are imbedded in imported text that is used in creating
many of the comments on a page using a VBA procedure.

So the question is, what is the code sequence of the carriage return typed
in when one hits Enter in inserting a comment into a spreadsheet?

Thank you.

John Wirt


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Carriage return character in combobox SteveZmyname Excel Discussion (Misc queries) 0 March 12th 10 04:32 PM
How to remove or replace a carriage return character in a cell? Patty Excel Discussion (Misc queries) 2 July 26th 05 06:25 PM
Function to return Character Position of Xth character within a string Andibevan[_2_] Excel Programming 4 June 9th 05 03:24 PM
How do I ignore newline character/carriage return while importing Achal Excel Discussion (Misc queries) 6 March 24th 05 02:24 AM
Carriage return in comment not working dumbass Excel Programming 5 June 1st 04 11:11 PM


All times are GMT +1. The time now is 02:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"