Tips.Net > WordTips Home > Macros > VBA Examples > Converting Inches to Points
Converting Inches to Points
Summary: Points are a common measurement and often used to specify linear distances in Word. When writing VBA macros, you can use a handy built-in function to quickly convert a measurement in inches into the correct measurement in points. (This tip works with Microsoft Word 97, Word 2000, Word 2002, and Word 2003.)
A point is a typographical measurement that is quite small. Points are used to specify many typographical elements, such as font size and line spacing. This means that when writing macros, it may be helpful to convert from a familiar measurement (such as inches) to the equivalent measurement in points.
There are approximately 72 points per inch. This means that you could simply multiply a measurement in inches by 72 in order to derive a result. However, VBA also provides a method that does the conversion for you. Simply use the InchesToPoints method, as follows:
Selection.ParagraphFormat.SpaceAfter = InchesToPoints(0.1)
This example sets the space after a paragraph equal to one-tenth of an inch. VBA takes care of the necessary conversion from inches to points.
Tip #1448 applies to Microsoft Word versions: 97 2000 2002 2003
Take Control! Master the real power behind Word! Successfully master the secrets of powerful formatting and create documents that stand out from the rest. Best of all, you can create documents that are easy to maintain and quick to change.
Check out Word 2007 Styles and Templates today!
The Ultimate Library!
Do you want a decade of WordTips information at your fingertips? You can find what you need with the WordTips Ten-Year Library. (more information...)
Helpful Links
Ask a Word Question
Make a Comment
Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips