Microsoft Office Forums - View Single Post

gurp99 · 03-14-2012, 09:12 AM

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