Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
shapes "linked" to cells?
could anybody possibly explain the following to me:
presume I insert a textbox to a worksheet the top/left corner of which is "over" cell C7 for example when I change the height of row 7 or width of column C the textbox size "adjusts" to those changes as if it was somehow "linked" to cell C7 - is it true? if so can anyone explain this to me or send a link where I could read about it (cause I never found any info on this) I know that Shapes objects uses different coordinate system than worksheet cells and Windows system windows thks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
shapes "linked" to cells?
Right click the shape (with your textbox rt-click on a border),
Properties... Notice the three move/size options. From what you described your textbox is set to "Move and size with cells" Regards, Peter T "Jarek Kujawa" wrote in message ... could anybody possibly explain the following to me: presume I insert a textbox to a worksheet the top/left corner of which is "over" cell C7 for example when I change the height of row 7 or width of column C the textbox size "adjusts" to those changes as if it was somehow "linked" to cell C7 - is it true? if so can anyone explain this to me or send a link where I could read about it (cause I never found any info on this) I know that Shapes objects uses different coordinate system than worksheet cells and Windows system windows thks in advance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
shapes "linked" to cells?
I have known that option
thks for reminding though thus this is the only answer to my question? On 6 Lis, 10:44, "Peter T" <peter_t@discussions wrote: Right click the shape (with your textbox rt-click on a border), Properties... Notice the three move/size options. From what you described your textbox is set to "Move and size with cells" Regards, Peter T "Jarek Kujawa" wrote in message ... could anybody possibly explain the following to me: presume I insert a textbox to a worksheet the top/left corner of which is "over" cell C7 for example when I change the height of row 7 or width of column C the textbox size "adjusts" to those changes as if it was somehow "linked" to cell C7 - is it true? if so can anyone explain this to me or send a link where I could read about it (cause I never found any info on this) I know that Shapes objects uses different coordinate system than worksheet cells and Windows system windows thks in advance- Ukryj cytowany tekst - - Poka¿ cytowany tekst - |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
shapes "linked" to cells?
The basic coordinate system for shapes is position (points from top left
corner) and size (width & height) in points. Shapes are indirectly linked to cells inasmuch as they have TopLeftCell and BottomRightCell properties (as range objects). If a gridline on left or top border of the 'TopLeftCell' changes the shape's position will change. If an intersecting gridline changes the shape will resize, also bottom/right gridline if the shape's bottom or right border was on the gridline originally, subject move & size option. Not sure if that covers your question. Regards, Peter T "Jarek Kujawa" wrote in message ... I have known that option thks for reminding though thus this is the only answer to my question? On 6 Lis, 10:44, "Peter T" <peter_t@discussions wrote: Right click the shape (with your textbox rt-click on a border), Properties... Notice the three move/size options. From what you described your textbox is set to "Move and size with cells" Regards, Peter T "Jarek Kujawa" wrote in message ... could anybody possibly explain the following to me: presume I insert a textbox to a worksheet the top/left corner of which is "over" cell C7 for example when I change the height of row 7 or width of column C the textbox size "adjusts" to those changes as if it was somehow "linked" to cell C7 - is it true? if so can anyone explain this to me or send a link where I could read about it (cause I never found any info on this) I know that Shapes objects uses different coordinate system than worksheet cells and Windows system windows thks in advance- Ukryj cytowany tekst - - Poka¿ cytowany tekst - |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
shapes "linked" to cells?
it really does
thks a million Peter On 6 Lis, 14:18, "Peter T" <peter_t@discussions wrote: The basic coordinate system for shapes is position (points from top left corner) and size (width & height) in points. Shapes are indirectly linked to cells inasmuch as they have TopLeftCell and BottomRightCell properties (as range objects). If a gridline on left or top border of the 'TopLeftCell' changes the shape's position will change. If an intersecting gridline changes the shape will resize, also bottom/right gridline if the shape's bottom or right border was on the gridline originally, subject move & size option. Not sure if that covers your question. Regards, Peter T "Jarek Kujawa" wrote in message ... I have known that option thks for reminding though thus this is the only answer to my question? On 6 Lis, 10:44, "Peter T" <peter_t@discussions wrote: Right click the shape (with your textbox rt-click on a border), Properties... Notice the three move/size options. From what you described your textbox is set to "Move and size with cells" Regards, Peter T "Jarek Kujawa" wrote in message .... could anybody possibly explain the following to me: presume I insert a textbox to a worksheet the top/left corner of which is "over" cell C7 for example when I change the height of row 7 or width of column C the textbox size "adjusts" to those changes as if it was somehow "linked" to cell C7 - is it true? if so can anyone explain this to me or send a link where I could read about it (cause I never found any info on this) I know that Shapes objects uses different coordinate system than worksheet cells and Windows system windows thks in advance- Ukryj cytowany tekst - - Poka¿ cytowany tekst -- Ukryj cytowany tekst - - Pokaż cytowany tekst - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linked cells show "0" | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Multiple "source" workbooks linked to single "destination" workboo | Excel Worksheet Functions | |||
Protecting "linked cells" | Excel Discussion (Misc queries) | |||
Using "Cells" to write "Range("A:A,H:H").Select" | Excel Programming |