Tips.Net > WordTips Home > Macros > VBA Examples > Determining if Overtype Mode is Active
Determining if Overtype Mode is Active
Summary: Is your VBA macro running with overtype mode active? This code will let you know. (This tip works with Microsoft Word 97, Word 2000, Word 2002, and Word 2003.)
If you are using a macro that inserts text in a document, you might want to determine if the overtype mode is active. This is the typing mode that results in every keypress replacing an existing character in the file. If you don't check for this, your macro could have undesired results. The following line of VBA macro code checks the status of the overtype mode turns it off if it is on.
If Options.OverType Then Options.OverType = False
Tip #755 applies to Microsoft Word versions: 97 2000 2002 2003
Find and Replace Almost Anything! An invaluable resource for learning how to harness the full power of Word's search and replace capabilities. You'll discover everything you need in order to master all the intricacies of finding and replacing elements of your document, including the super-powerful ?wildcard searches? available in Word.
Check out WordTips: Find and Replace today!
Great Support Resource!
If you provide support and help to others, you need the power offered in the WordTips Ten-Year Library. There is no better information repository anywhere! (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