
Tips.Net > WordTips Home > Macros > VBA Examples > Determining How Many Styles are Available
Summary: When writing a macro, you may need to know how many styles are defined in a document. This tip discloses the techniques you can use to figure out just what you need. (This tip works with Microsoft Word 97, Word 2000, Word 2002, and Word 2003.)
You can determine the number of styles available in a document (when creating a VBA macro) by using the Count property with the Styles object. This is done using the following syntax:
x = ActiveDocument.Styles.Count
where x is the variable you can then use in other VBA macro lines. Note that this function indicates how many have been defined, not how many of those are actually in use. This means that built-in styles are also counted. If you want to exclude built-in styles, you can do an actual iterative count of the styles in this manner:
x = 0
For Each objStyle in ActiveDocument.Styles
If Not objStyle.BuiltIn Then x = x + 1
Next objStyle
Tip #803 applies to Microsoft Word versions: 97 2000 2002 2003
Create and Merge! Using Word's mail merge tool you can quickly and easily combine data from a variety of data sources to create great individualized documents that incorporate your data in ways that you control. WordTips: Mail Merge Magic is an invaluable source for learning how to harness the full power of Word's mail merging capabilities.
Check out WordTips: Mail Merge Magic today!
Have thousands of WordTips at your fingertips, on your own system. Answer your own questions or help support others. (more information...)
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