+ Reply to Thread
Results 1 to 1 of 1

Square shapes change it's names when value in the list changed

  1. #1
    Registered User
    Join Date
    10-18-2011
    Location
    Miami
    MS-Off Ver
    Excel 2003
    Posts
    6

    Square shapes change it's names when value in the list changed

    I have file with VBA that change shape names based on 2 lists data...
    1 list contain data like home, building, elevator etc... second has digits 1.2.3 etc. so every shape match it's name in namebox (not text in shape) to those two lists like home1, home2, builidng1, building2 etc...
    check image Click for image

    Script works fine if you only changing first list home, building, elevator but what I need VBA change to shape names when I change second column and use text instead of numbers 1,2,3, so it will be like

    list1 list2
    home left

    so I change left to right and shape update it's name to homeright

    check file
    Click for file



    VBA

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

+ 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