+ Reply to Thread
Results 1 to 5 of 5

Sizing a picture based on a value.

  1. #1
    Registered User
    Join Date
    11-05-2007
    Posts
    82

    Sizing a picture based on a value.

    All,

    I have a spreadsheet with a number of Ovals created within it, I want to try and get the Ovals to change size based on a table of values on another sheet.

    The table of values will have anything from 1 to 5, and for eacxh value I want the Oval to change, so 5 it will be large, and 1 will be small.

    Can anyone help - I'm sure that its a simple one?

    Thanks in advance

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202
    Something like this, change the oval's name to suit & the sheet 7 cell references. Use the WorkSheet_Change event
    Please Login or Register  to view this content.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    11-05-2007
    Posts
    82
    Seems to work.

    However - I'm not sure what the 1st line of code does.

    Please Login or Register  to view this content.
    Could you explain?
    Last edited by Andy Pope; 09-02-2008 at 03:47 AM.

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,174
    That line in Roy's code means that the following code will only be actioned if the cell be changed is A1.
    Cheers
    Andy
    www.andypope.info

  5. #5
    Registered User
    Join Date
    11-05-2007
    Posts
    82
    I see - I was thinking that only if the Oval is linked to Cell A1 will the change go ahead.

    Thanks for all your help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Display Picture Based on a Cell Value
    By modytrane in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-27-2007, 04:57 PM
  2. Replies: 18
    Last Post: 10-11-2007, 04:19 AM
  3. Picture based on cell content
    By JEB in forum Excel General
    Replies: 4
    Last Post: 07-17-2007, 06:47 PM
  4. Inserting picture filenames in an excel list
    By tryer in forum Excel General
    Replies: 0
    Last Post: 05-01-2007, 05:04 PM
  5. Imported Picture Pastes randomly.
    By texx2000 in forum Excel General
    Replies: 4
    Last Post: 11-03-2006, 10:14 AM

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