| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alt Enter vs. Chr(13)
I have entered text into an autoshape and used "Alt-Enter" as CR/LF while
inputting the text. Now reading that text thru vba, I'm trying to replace the Alt_Enter (shows up as a square in my text string) with a space by using; txt_1= ActiveSheet.Shapes(SelectedShape).DrawingObject.Ca ption txt_2= Replace(txt_1, Chr(13), " ") This does not work. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to select cells in column enter data then press enter | New Users to Excel | |||
| Enter multiple numbers in a cell so total shows when enter keypres | Excel Worksheet Functions | |||
| Enter info in one sheet, auto enter in another based on one field | New Users to Excel | |||
| Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
| What does hitting Ctrl + Shift + Enter to enter a formula do??? Help a n00b out. | Excel Worksheet Functions | |||
Threaded Mode
