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
Textbox text extract and return back.xls
Description: MS-Excel spreadsheet
