+ Reply to Thread
Results 1 to 5 of 5

Shapes Quantity match Cell Value

  1. #1
    Registered User
    Join Date
    10-12-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    62

    Shapes Quantity match Cell Value

    If I have a value in Cell A1, I would like the same "amount" of shapes to show on sheet in the columns to the right of it.

    Example: A1 = 4
    B1 would have an Oval in it.
    C1 would have an Oval in it.
    D1 would have an Oval in it.
    E1 would have an Oval in it.

    Each time I changed the value in A1 it would give me that amount of shapes. I would like to do this for about 50 rows in Column A.

    If you know the answer or could send me to a tutorial, that would be awesome.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Shapes Quantity match Cell Value

    Check it out, Change the number in A1 to see the Ovals

    The code is in the Worksheet Module.

    RightClick.jpg

    Code Used,

    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    10-12-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    62

    Re: Shapes Quantity match Cell Value

    that is great. Is there a way to transpose the ovals so they run across columns? i.e., B1, C1, D1, E1)

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Shapes Quantity match Cell Value

    oh Ya,
    Just do it,
    Notice that each Oval has a Name
    Oval 1
    Oval 2
    Oval 3
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    10-12-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    62

    Re: Shapes Quantity match Cell Value

    I see, that is clever. It really helps! Thank you very much!

+ 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. [SOLVED] vlookup or index match, to manage quantity?
    By raffi123 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-14-2013, 06:09 PM
  2. [SOLVED] Get Total Quantity of Parts That Match List?
    By stusic in forum Excel General
    Replies: 3
    Last Post: 07-12-2013, 03:24 PM
  3. Replies: 0
    Last Post: 07-26-2012, 02:09 AM
  4. Shapes based on Cell Data, Golf Score card data that shows shapes around scores
    By BiggDC1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-12-2012, 12:42 PM
  5. Replies: 3
    Last Post: 02-08-2012, 02:44 AM

Tags for this Thread

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