 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / May 2007pasting text into a text box
For some reason I am unable to paste text into a chart text box, (with excel 2007). Is there a trick to this? Gary K. Five minutes with Excel 2007 show that there is no obvious way to paste copied text into the embedded text box. Aren't you glad you upgraded? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ > For some reason I am unable to paste text into a chart text box, > (with excel 2007). > > Is there a trick to this? > Gary K. I could only paste text in to a textbox if I copy the text from another textbox. If I copied a cell containing the new text pasting resulted in a new series being added. Regardless of how I tried to select the textbox to give it focus. If I copied the text in a cell from the formula bar the Paste feature was disabled when I selected the textbox. All a bit hit and miss :( Cheers Andy > Five minutes with Excel 2007 show that there is no obvious way to paste > copied text into the embedded text box. Aren't you glad you upgraded? [quoted text clipped - 11 lines] >>Is there a trick to this? >>Gary K. I'm disappointed in you guys, the solution is really straightforward. 1. don't uninstall 2003 when you install 2007 2. Create a textbox with some text in your 2007 file. 3. Create a dummy chart in 2003 Excel 4. Create a textbox in 2003 and paste the text there 5. Save the dummy 2003 file 6. Open the dummy file in 2007 7. Copy and paste the text from the dummy textbox. Now, if I only could record a macro in 2007, I could automate this. > I could only paste text in to a textbox if I copy the text from another > textbox. [quoted text clipped - 26 lines] > >>Is there a trick to this? > >>Gary K. "really straightforward" Take that tongue out of your cheek before you choke on it! - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ > I'm disappointed in you guys, the solution is really straightforward. > [quoted text clipped - 38 lines] >> >>Is there a trick to this? >> >>Gary K. Actually, I just discovered that you can simplify the whole process by creating the textbox in Word. Even Word 2007 But it isn't as much fun. I copied text from Notepad, and it worked. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ >I could only paste text in to a textbox if I copy the text from another >textbox. [quoted text clipped - 26 lines] >>>Is there a trick to this? >>>Gary K. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.