Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #9  
Old 03-14-2012, 09:12 AM
gurp99 gurp99 is offline Text Spacing in document Windows Vista Text Spacing in document Office 2007
Novice
Text Spacing in document
 
Join Date: Apr 2010
Posts: 18
gurp99 is on a distinguished road
Default

This is the code I have. I have a Update and a Change event. Should I remove the change event?
and what does vbCr, ", " mean?


Code:
Private Sub txtEnclosureAttached_Update()
Dim Rng As Range
Set Rng = ActiveDocument.Bookmarks(bmkEnclosureAttached).Range
    Rng.Text = Replace(txtEnclosureAttached.Text, vbCr, ", ")

Application.ScreenRefresh
ActiveDocument.Bookmarks.Add "bmkEnclosureAttached", Rng
End Sub



Private Sub txtEnclosureAttached_Change()
Dim Rng As Range
Set Rng = ActiveDocument.Bookmarks("bmkEnclosureAttached").Range
    Rng.Text = Replace(txtEnclosureAttached.Text, vbCr, ", ")

Application.ScreenRefresh
ActiveDocument.Bookmarks.Add "bmkEnclosureAttached", Rng
End Sub
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Bug in PPT 2007 - Font and line spacing in text boxes Amateur PowerPoint 0 09-01-2010 03:34 AM
How do I import text columns with specified spacing between words w/o losing format? Fucius Word 0 08-09-2010 06:23 PM
Text Spacing in document Import Text from File - Line Spacing marshalx Word 2 10-28-2009 02:37 AM
Print spacing in Word document veekay99 Word 16 04-21-2009 01:18 AM
How to link text from one document to another nospamforyou Word 0 10-09-2008 09:14 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:31 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft