Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How To, Drawingobject Text Boxes:
Hi TWIMC,
Is there a way to link one drawingobject text box content to another drawingobject text box in a different workbook file? I've managed to do it using Form Text Boxes using the LinkedCell property but my boss wants to keep the different formats of text that are contained in the current drawingobject text box, (in that theres lots of text in the text box with headers that are in bold, which a Form text box can't do). I've looked at using worksheet(report).drawingobjects("Commentary 1") = worksheet(source1).drawingobjects("Commentary 1").value The thing is that will this keep the format of the text and how can I loop through all the text boxes on each sheet within the workbook? Just some backgroud, the Text boxes in all source workbooks have the same sheet name and text box name that is in the one report. Each workbook coming in have different sheet names, e.g. the German workbook file contains Germany, the UK workbook contains UK, the report workbook contains Germany and UK, so as you can see I want to be able to take all workbooks in a folder (Application.FileSearch etc etc), process them one by one, take all the comments in their sheet and add them to the report sheet comments, and no I can't import the sheet in the workbook coming from each country/location since the management report is a different layout and overview in that some comments for some countries/locations are to amended together. TIA KM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default font for pasted text in text boxes - Excel 2007 | Excel Discussion (Misc queries) | |||
User Form Text Boxes - Copy format of text boxes | Excel Discussion (Misc queries) | |||
How to Import Visio Text Boxes into Excel as Text | Excel Discussion (Misc queries) | |||
How do I link Text Boxes to Cells, not Cells to Text Boxes? | Excel Worksheet Functions | |||
In Excel, option to enter text in cells the same as text boxes | Excel Worksheet Functions |