+ Reply to Thread
Results 1 to 3 of 3

Use variable property name

  1. #1
    Registered User
    Join Date
    12-13-2012
    Location
    Hamburg
    MS-Off Ver
    Excel 2010
    Posts
    13

    Use variable property name

    Hey guys,

    I am trying to change the paths ta large number of image locations depending on a condition. Those images are ordered in an 6 by 24 matrix. For that I have named the images systematically. With two for loops I would like check whether a condition is met and based on the result change the path to the image, respectively.

    My form on which the images are placed is called FormDelta. The 144 images are on this form and I thought I could addres them by defining a string and then use it in the FormDelta properties. However, that seems not to be allowed.

    Do you guys know a better approach to my problem? I hope it was clear enough, otherwise I am happy to clarify!

    Thanks for your time in advance!
    Konfis


    I have the following code:
    Please Login or Register  to view this content.

  2. #2
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Use variable property name

    konfis,

    Welcome to the forum!
    You'll need to reference the image controls in this manner:
    Please Login or Register  to view this content.
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    12-13-2012
    Location
    Hamburg
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Use variable property name

    Hey tigeravatar,

    thanks a lot for the quick reply. It works like a charme

    Have a good weekend!

+ 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