You didn't include your code. Did you want us to rewrite it too? the code you have for extracting the contents is very close to what is needed to replace it.
Paul ----- Original Message ---- > From: Chandru <chandr...@gmail.com> > To: excel-macros@googlegroups.com > Sent: Thu, September 16, 2010 7:03:28 AM > Subject: $$Excel-Macros$$ Extract the text from Textbox and return back after >editing > > Hello experts > > I wish to have an excel macro that can extract text from all the text > boxes from one sheet and then list out that text in another sheet. I > can find some macros for this from the internet. Now my requirement is > to return back that text to the same text box after editing. I am not > able to find macro for this after googling as of now. > > The first sheet contains the original text with some text boxes. > Please note that some text boxes are grouped. Now a macro should > extract the text and list that in the column B in a new sheet (or in a > new workbook based on programmers convenience). I will now edit the > text and type the same in column C. The editing work may take some > time based on the amount of text. If possible, the address may be > displayed in column A. > > After editing, I need another macro to send the text back to the same > text box from where it was extracted. Hope I have explained my point. > I have attached a sample excel file. If I am not asking for more, I > would like the same for the comments in the cells also. All comments > to be extracted to the new sheet after the text box text. Then editing > will be done. Then it needs to be pushed back to the same place. > > Thanks in advance > Chandru > > -- >---------------------------------------------------------------------------------- >- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : >http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the >learning and support from the group.Let friends and co-workers know they can >subscribe to group at http://groups.google.com/group/excel-macros/subscribe > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
