| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Obtain an objects current location
Hi
I would like to be able to obtain an objects current location so that it can be automatically moved based on its current position. Can you get an objects current X and Y location in points? If so what is the command? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Obtain an objects current location
A Shape, Chart and OLEobject have a TopLeftCell property.
-- Jim Cone Portland, Oregon USA "Jive" wrote in message ... Hi I would like to be able to obtain an objects current location so that it can be automatically moved based on its current position. Can you get an objects current X and Y location in points? If so what is the command? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Obtain an objects current location
Activesheet.drawingobjects("Rectangle 1").Top
Activesheet.drawingobjects("Rectangle 1").Left or use the index number as Activesheet.drawingobjects(1).Top If this post helps click Yes --------------- Jacob Skaria "Jive" wrote: Hi I would like to be able to obtain an objects current location so that it can be automatically moved based on its current position. Can you get an objects current X and Y location in points? If so what is the command? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why objects inserted in excel move to different location in print | Excel Discussion (Misc queries) | |||
| How to obtain current selection using C++ | Excel Programming | |||
| Macro - save to current location vs excel default location | Excel Discussion (Misc queries) | |||
| Obtain current RGB settings for color indexes 17 thru 27 | Excel Programming | |||
| how can one obtain the current selected cell value | Excel Programming | |||
Hybrid Mode
