Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
KBArticle 169972 says:
In Microsoft Excel 97 for Windows, if you use these constants when you insert text into a text box or into a cell, a square character may appear in the text box or cell. This problem occurs if you use any of the following constants: vbBack vbCr vbCrLf vbNewLine vbTab .......You can remove the square character by manually editing the cell. ______________________________ I have found that this behavior is also in Excel 2000 and XP. The KB article above is a couple years old. Has anyone found a solution to removing the boxes programmatically. I've tried everything I can think of. Thanks joan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I a rotate my square radar chart (square-diamond)? | Charts and Charting in Excel | |||
Data validation boxes, outputting a final number from the boxes | Excel Discussion (Misc queries) | |||
how to center a square plot area in a square chart | Charts and Charting in Excel | |||
Compile Error in Excel 2004 when Inputbox contains "VBCRLF" | Excel Discussion (Misc queries) | |||
Regression Output -- R Square versus Adjusted R Square | Excel Discussion (Misc queries) |