| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
missing chars in a comment box
I have a VBA program where the user can input text in a userform textbox. This text is copied to the commentbox using 'addcomment(textcomment.text)' . It works fine when no <enter button is used in the comment text. In the latter case, a tine square box is displayed (for the linefeed/cr char?) between the lines were it was pushed. How can I avoid this square box? thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
missing chars in a comment box
sStr = Replace(Textbox1.Text,chr(10),"")
and put sStr into your comment Assumes xl2000 or later. Post back if you or your users are using xl97. -- Regards, Tom Ogilvy "Roland" wrote in message ... I have a VBA program where the user can input text in a userform textbox. This text is copied to the commentbox using 'addcomment(textcomment.text)' .. It works fine when no <enter button is used in the comment text. In the latter case, a tine square box is displayed (for the linefeed/cr char?) between the lines were it was pushed. How can I avoid this square box? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to truncate list of meaningful words greater than 15 chars tomeaningful words of 8 chars. | Excel Worksheet Functions | |||
| Inserting word object - Missing the comment feature in ribbon | New Users to Excel | |||
| sum first 2 chars if 3rd is something... | Excel Discussion (Misc queries) | |||
| determine if ea value in a col has more than 20 chars | Excel Discussion (Misc queries) | |||
| I have one missing comment indicator amongst several. How can i c. | Excel Discussion (Misc queries) | |||
Linear Mode
