+ Reply to Thread
Results 1 to 2 of 2

A macro after setting onaction for a shape that will select the shape.

  1. #1
    Registered User
    Join Date
    09-30-2013
    Location
    Nelson Bay, Australia
    MS-Off Ver
    Excel 2003
    Posts
    23

    A macro after setting onaction for a shape that will select the shape.

    Good afternoon,

    I've got a macro that adds a shape and sets its parameters. I've then got...

    Please Login or Register  to view this content.
    to ensure that a Macro is run when I click the shape.

    The problem is that for the macro to work, I need to select the shape that has been clicked on, i.e.

    Please Login or Register  to view this content.
    As the name of the shape will vary depending on which shape I click on, I figure selecting the clicked on shape will be the best solution.

    Any ideas.

  2. #2
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,376

    Re: A macro after setting onaction for a shape that will select the shape.

    Hi vonRobbo,
    maybe something like this
    Please Login or Register  to view this content.

+ 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. Macro to Select Shape to Print
    By josephteh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-02-2014, 09:18 PM
  2. Select a shape based on a cell value and update the shape when value changes
    By BigAl99 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-14-2013, 12:06 PM
  3. [SOLVED] Use a button to control a macro that inserts an image into a shape or resets the shape
    By nwb in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-13-2013, 04:41 PM
  4. Replies: 0
    Last Post: 11-30-2012, 01:29 PM
  5. Capturing Shape Name/Text from OnAction property
    By William Bartusek in forum Excel General
    Replies: 3
    Last Post: 04-12-2005, 02:06 PM

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