Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is it possible to link the cell in excel to the size of the shape
Within Visio, you would need VBA code that references the various Excel object, and reads the value
of the correct cell: using code like myValue = xlObject.xlWorkbookObject.xlWorksheetObj.Range("Ad dress").Value Then you could scale the size of the drawing object based on myValue HTH, Bernie MS Excel MVP "reallylost" wrote in message ... Hi! I was hoping i could get some help. I am currently designing a reactor, but my calculations in excel keep changing the final size of the reactor. Is it possible to link the cell in excel to the size of the shape in visio? For instance if the calculations come to a height of 7cm, can visio automatically take this number and adjust the reactor height accordingly Any help is much appreciated Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Building a process in Excel. How do I see the size of the shape, | Setting up and Configuration of Excel | |||
how do i link shape to a cell in excel | Excel Discussion (Misc queries) | |||
Cell comment boxes shouldn't change size/shape unless changed by u | Excel Discussion (Misc queries) | |||
Shape Size in Cell | Excel Programming | |||
Deleting a shape and the cell contents the shape is in. | Excel Programming |