+ Reply to Thread
Results 1 to 7 of 7

Positioning multiple shapes based on cell values

  1. #1
    Registered User
    Join Date
    02-15-2016
    Location
    Singapore
    MS-Off Ver
    O365
    Posts
    5

    Positioning multiple shapes based on cell values

    I'm looking for help with positioning multiple shapes based values which are stored in cell references.
    My current code positions them individually, but if possible, I would like to create a loop to simplify the solution

    Sheet 2 contains the cell reference for positioning & size
    Sheet 4 contains the actual shape.

    Please Login or Register  to view this content.
    Thanks for taking time to look at this

  2. #2
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,220

    Re: Positioning multiple shapes based on cell values

    Please Login or Register  to view this content.
    Artik

  3. #3
    Registered User
    Join Date
    02-15-2016
    Location
    Singapore
    MS-Off Ver
    O365
    Posts
    5

    Re: Positioning multiple shapes based on cell values

    Thanks Artik, however
    Please Login or Register  to view this content.
    is returning runtime error 1004

  4. #4
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,220

    Re: Positioning multiple shapes based on cell values

    If I have something to test the code on, I will tell you what the problem is. I don't know what it looks like with you and I will not guess.

    Artik

  5. #5
    Registered User
    Join Date
    02-15-2016
    Location
    Singapore
    MS-Off Ver
    O365
    Posts
    5

    Re: Positioning multiple shapes based on cell values

    Hi Artik, here is a version of my file. Thank you
    Attached Files Attached Files

  6. #6
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,220

    Re: Positioning multiple shapes based on cell values

    Oops. Instead of
    Please Login or Register  to view this content.
    it should be
    Please Login or Register  to view this content.
    Artik

  7. #7
    Registered User
    Join Date
    02-15-2016
    Location
    Singapore
    MS-Off Ver
    O365
    Posts
    5

    Re: Positioning multiple shapes based on cell values

    Many thanks Artik, everything is working perfectly now

+ 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. Making VBA Macro to make shapes disappear if cell has certain value (Multiple Shapes)
    By Nicholaes in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-29-2019, 06:33 PM
  2. [SOLVED] How to hide shapes based on numerous cell values
    By willastrowalker in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-20-2017, 02:50 AM
  3. Colour shapes based on cell values in a lookup
    By aimone111 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2015, 09:57 PM
  4. Please Help: Resize multiple shapes in the same sheet based on cell value
    By BartekKonopka in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-19-2013, 02:27 PM
  5. VBA to Show/Hide multiple shapes based on cell values
    By Mike_Taylor16 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-22-2013, 03:29 PM
  6. Change color of shapes based on cell values.
    By rkostner in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-24-2013, 05:55 PM

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