Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 683
Default Shape Change Event

Jim,

I got the following to work when I right-clicked the shape and put assign
macro.

Sub Rect1_Click()
MsgBox Worksheets(1).Shapes("Rect1").Top & ", " _
& Worksheets(1).Shapes("Rect1").Left
End Sub

--
Brian


"Jim Thomlinson" wrote:

The short answer is no. Shapes do not have events associated with them. Even
if they did to move or change a shape you essentailly have to put the sheet
into Design Mode. When you are in Design mode macros don't run.
--
HTH...

Jim Thomlinson


"Brian" wrote:

Hello All,

I was wondering if it's possible to write an event based on a change in the
position of a shape. Let's just say, for simplicity sake, that when a user
changes the position of a shape, named "Rect1" that the new position of the
shape is displayed in a MsgBox.

Thanks in advance.
--
Brian

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trap Mouse Move event for Images inside the shape or Image control jd Excel Programming 1 September 25th 08 11:21 AM
apply cell change event to single column - WorksheetChange Event [email protected] Excel Programming 6 May 4th 08 02:28 AM
Triggering an event whenever a new shape is added in a sheet Sagittarian Excel Programming 1 June 21st 07 12:59 AM
Trapping Add Shape Event jgb103 Excel Programming 0 May 15th 06 03:11 PM
Shape Selection Event !! RAFAAJ2000[_2_] Excel Programming 3 May 29th 05 08:42 PM


All times are GMT +1. The time now is 02:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"