+ Reply to Thread
Results 1 to 5 of 5

Excel 2007 : Controlling shape attributes from cells values

  1. #1
    Registered User
    Join Date
    09-02-2009
    Location
    Norman, USA
    MS-Off Ver
    Excel 2003
    Posts
    7

    Controlling shape attributes from cells values

    Friends,
    I have recently posted a thread (http://www.excelforum.com/excel-misc...ll-values.html) in which I asked how to control the transparency of a shape via values in the cell. Andy Pope provided a solution (thanks again Andy!). But in my stupidity I can't figure out, how to adjust this code in order to change another attribute of a shape, namely it's size. I guess my failure to do so rests in lack of knowledge of codewords that are responsible for particular attributes. Could someone guide me to a resource that would help me learn them? (A quick word on how to solve it for the size-attribute would be very much appreciated to). Thanks!

    Andrey

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Controlling shape attributes from cells values

    A shape's size is defined by its Height and Width properties.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    09-02-2009
    Location
    Norman, USA
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Controlling shape attributes from cells values

    Quite so, but the values of Height and Width is what I need to be able to control from cells on the spreadsheet. I need to find out is how to write UDF which would link these properties to the specified cells.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Controlling shape attributes from cells values

    Following Andy's example,
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    09-02-2009
    Location
    Norman, USA
    MS-Off Ver
    Excel 2003
    Posts
    7

    Thumbs up Re: Controlling shape attributes from cells values

    Thanks, Shg!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1