| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Positioning of figures
Hi!
With the command ActiveSheet.Shapes.AddLine(300#, 300#, 300#, 300#).Select it is easy to draw figures on the position that u want (upper left corner is determed by the first two numbers) I am looking for the invers of this formular: I want to get to know the position of the upper left corner of a figure on an unknown place on my sheet. Can anyone help me!? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Positioning of figures
ActiveSheet.Shapes(Name).Left and ActiveSheet.Shapes(Name).Top give the
coordinates of the figures. Thx. "BZA" schreef: Hi! With the command ActiveSheet.Shapes.AddLine(300#, 300#, 300#, 300#).Select it is easy to draw figures on the position that u want (upper left corner is determed by the first two numbers) I am looking for the invers of this formular: I want to get to know the position of the upper left corner of a figure on an unknown place on my sheet. Can anyone help me!? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What is absolute positioning? | New Users to Excel | |||
| add figures to existing figures in excel | Excel Worksheet Functions | |||
| Changing positive figures to minus figures | Excel Worksheet Functions | |||
| UserForm positioning | Excel Programming | |||
| = positioning | Excel Programming | |||
Hybrid Mode
