Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
go1angel
 
Posts: n/a
Default 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   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



  #3   Report Post  
go1angel
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Text in formula bar is not displaying in cell Mike Excel Discussion (Misc queries) 0 August 29th 05 09:47 PM
Macro to change cell text color James C Excel Discussion (Misc queries) 1 August 12th 05 06:59 PM
copying cell names Al Excel Discussion (Misc queries) 12 August 11th 05 03:01 PM
Possible to insert cell data in the middle of line of text? Bob Smith Excel Worksheet Functions 6 July 29th 05 08:14 PM
Formatting a cell as "text" in the number catagory. Ed Excel Worksheet Functions 3 December 7th 04 08:12 PM


All times are GMT +1. The time now is 08:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"