Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need a macro to insert text in a cell that already has text.Excel
I want a macro that will allow me insert text in a cell where I have placed
my curser. Sounds easy. Hope it is. Help! Sharon |
#2
|
|||
|
|||
Sub PlaceText()
ActiveCell.Value = "ABCD" End Sub if you mean you are editing a text string in a cell and you want to insert text within the text string, then there is no direct support for that. For any practical application, macros do not run when you are in edit mode. Try copying the text string to add by selecting just the text and doing Ctrl+c now where your cursor is in the cell where you want it added, do Ctrl+v -- Regards, Tom Ogilvy "go1angel" wrote in message ... I want a macro that will allow me insert text in a cell where I have placed my curser. Sounds easy. Hope it is. Help! Sharon |
#3
|
|||
|
|||
Thanks, that is what I have been doing. But it seemed like an easy thing. But
I am in edit mode so it won't work then. Thanks for your help. Sharon "Tom Ogilvy" wrote: Sub PlaceText() ActiveCell.Value = "ABCD" End Sub if you mean you are editing a text string in a cell and you want to insert text within the text string, then there is no direct support for that. For any practical application, macros do not run when you are in edit mode. Try copying the text string to add by selecting just the text and doing Ctrl+c now where your cursor is in the cell where you want it added, do Ctrl+v -- Regards, Tom Ogilvy "go1angel" wrote in message ... I want a macro that will allow me insert text in a cell where I have placed my curser. Sounds easy. Hope it is. Help! Sharon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text in formula bar is not displaying in cell | Excel Discussion (Misc queries) | |||
Macro to change cell text color | Excel Discussion (Misc queries) | |||
copying cell names | Excel Discussion (Misc queries) | |||
Possible to insert cell data in the middle of line of text? | Excel Worksheet Functions | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions |