Are These Coordinates?

M

mtonkovich

I recorded the following macro and I have no idea what the following
numbers in () are. Could someone please help?

ActiveChart.ChartArea.Select
With ActiveChart.TextBoxes.Add (338, 207, 374, 16)

Perhaps the numbers define the coordinates of the text box?

Yes/no?

Thanks in advance.

Mike
 
G

Greg Wilson

The first two define the Left and Top coordinates in points. The third and
fourth define the Width and Height in points.

Regards,
Greg
 
M

mtonkovich

Greg - Thank you for the help!

Mike
Greg said:
The first two define the Left and Top coordinates in points. The third and
fourth define the Width and Height in points.

Regards,
Greg
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to select and delete levels of a document 2
find corresponding coordinates on graph 1
Need macro from basic table to a reorganized table 0
how to dump freeform coordinates (a plot shape) 6
Stuck! need help 8
Excel: using data labels as markers 4
Macro to Select text from a point given to a specific word 2
Table design - multiple values 1

Top