ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Measurements in VBA/Excel (https://www.excelbanter.com/excel-programming/383519-measurements-vba-excel.html)

jayklmno

Measurements in VBA/Excel
 
If I write a line of code like Activesheet.rectangles.add 50, 50, 50, 50

What is the system of measurement Excel is using to Draw the rectangle at
Location 50,50 and 50 wide by 50 high?

Inquiring minds want to know...

Is it pixels? Inches? Twips?

Jim Cone

Measurements in VBA/Excel
 
From the help file...
'---
"Left, Top...Single. The position (in points) of the upper-left corner of the ...
relative to the upper-left corner of the document."

"Width, Height...Single. The width and height of the ..., in points."
---

There are 72 points to the inch.
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"jayklmno"
wrote in message
If I write a line of code like Activesheet.rectangles.add 50, 50, 50, 50
What is the system of measurement Excel is using to Draw the rectangle at
Location 50,50 and 50 wide by 50 high?
Inquiring minds want to know...
Is it pixels? Inches? Twips?


All times are GMT +1. The time now is 05:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com