View Single Post
  #2   Report Post  
Tom Ogilvy
 
Posts: n/a
Default

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