+ Reply to Thread
Results 1 to 4 of 4

Code to click a shape which is a control button

  1. #1
    Forum Contributor
    Join Date
    04-24-2012
    Location
    Moscow
    MS-Off Ver
    Excel 2010
    Posts
    291

    Code to click a shape which is a control button

    Hi please help

    i need a code for clicking a shape (which is a control button). I do not need a code for clicking a button.

    Is it possible?

  2. #2
    Forum Contributor
    Join Date
    06-16-2011
    Location
    London
    MS-Off Ver
    Excel XP
    Posts
    276

    Re: Code to click a shape which is a control button

    Just put your shape in there, right click on it and select 'assign macro'.

  3. #3
    Forum Contributor
    Join Date
    04-24-2012
    Location
    Moscow
    MS-Off Ver
    Excel 2010
    Posts
    291

    Re: Code to click a shape which is a control button

    when i ask "i need a code for clicking a shape" is exactly what i mean. Btw its just a button not a command button

  4. #4
    Forum Contributor
    Join Date
    06-16-2011
    Location
    London
    MS-Off Ver
    Excel XP
    Posts
    276

    Re: Code to click a shape which is a control button

    There is no 'code for clicking a shape'. You just click the shape.

    What do you want to happen when the shape is clicked? You write that code as a macro and then assign that macro to the shape. Then, when you click the shape, it'll run the assigned macro.

+ 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. Click on shape to return message box of shape name
    By beat in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-11-2013, 01:06 PM
  2. How I do disable and enable web browser control in access form on button click
    By krjoshi in forum Access Programming / VBA / Macros
    Replies: 0
    Last Post: 10-10-2013, 02:58 PM
  3. Click code for ActiveX control doesn't run in second Window
    By owenf in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-10-2013, 10:19 PM
  4. [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
  5. [SOLVED] Second Click on Control Button
    By iamjbunni in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-01-2006, 05:55 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