+ Reply to Thread
Results 1 to 5 of 5

The macro moves the shapes to specific words

  1. #1
    Registered User
    Join Date
    12-21-2018
    Location
    Samar
    MS-Off Ver
    Excel 2013
    Posts
    3

    The macro moves the shapes to specific words

    Hello, everyone.

    In the word document are of a Rectangle shape 4, 8 AutoShape
    Also there-in some places the words are written WORD-1, WORD-n.

    How a macro to do the move figures to these words ?
    Rectangle - to "WORD-1", Triangle - to"WORD-N".

    Now the figure can move only moving short distances.

    HTML Code: 
    Attached Files Attached Files

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: The macro moves the shapes to specific words

    For the autoshapes in your attachment (which have different names than those you referred to):
    Please Login or Register  to view this content.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Registered User
    Join Date
    12-21-2018
    Location
    Samar
    MS-Off Ver
    Excel 2013
    Posts
    3

    Re: The macro moves the shapes to specific words

    macropod, Thanks for your reply.

    This macro only works once. This is because the macro renames the shapes for some reason.
    Therefore, at the end of the script moved figures already have other names.

    Advise - how to move the figures without changing their names ?
    (This will allow to use the macro many times, not just once.)
    Last edited by bazanski; 12-25-2018 at 07:37 AM.

  4. #4
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: The macro moves the shapes to specific words

    If you wanted to be able to do this repeatedly, you should have said so in your original post. Try:
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    12-21-2018
    Location
    Samar
    MS-Off Ver
    Excel 2013
    Posts
    3

    Re: The macro moves the shapes to specific words

    macropod, Thanks so much. Everything works.

+ 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] macro find and replace in a specific column specific words to an abreviation
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-19-2018, 06:05 AM
  2. [SOLVED] Deleting specific shapes not all in excel - Macro
    By Mhay5656 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-24-2017, 11:10 PM
  3. Macro falling down at specific PPSlide.Shapes.Paste.Select
    By Matcham in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-02-2016, 09:00 AM
  4. [SOLVED] Macro to search for specific words in proximity to each other?
    By BPSJACK in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-25-2014, 11:55 AM
  5. [SOLVED] Macro 2010 to find words using an specific cel value
    By Fabmatos in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-23-2014, 10:11 AM
  6. [SOLVED] Macro delete rows containing specific words
    By mcranda in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-11-2013, 05:14 PM
  7. [SOLVED] Macro will work for a specific words in a row
    By romandotcom in forum Excel General
    Replies: 7
    Last Post: 06-14-2012, 03:55 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