To convert between points and pixels on a Windows operating system use the relationship pixels = 96/72*points. Windows assumes that there are 96 Dpi on the screen, so 96 pixels are equal to 1 inch which is equal to 72 points. ![]() ![]() If you set the top and left properties to 72 points then your form will be positioned 1 inch from the top corner or 96 pixels (in Windows). You will notice that if you position the VBA UserForm in pixel values it doesn’t quiet match to what you expect, that is because the property is in points. The point measure is used in graphics programs such as Photoshop, in font sizes, in Excel and VBA.įor example in EXCEL the UserForm.Left and UserForm.Top properties in VBA will return the distance of the top corner of the form in points. A point is measure of size and 1 point is equal to 1/72 inches, So 72 points are equal to 1 inch.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |