Print and clear

[rob p]

I have a userbox with approx. 20 fields that are filled in. An OK button is
coded as such:
-------------
Dim myRange As Range

With ActiveDocument
Set myRange = .Bookmarks("BK1").Range
myRange.Text = TextBox1.Text
.Bookmarks.Add "BK1", myRange
and so on...
End with

 

[Harold Kless[MSFT}]

Hi Rob,
From your description I would suggest that you use a template that contains
the code and userform.
A new document is created from the template which will display the default
values for the formfields and objects on the userform. When the print is
complete close the document without saving. Then create a new document from
the template.
The template is never opened directly in Word so it's values never change.


Harold Kless, MCSD
Support Professional
Microsoft Technical Support for Business Applications
(e-mail address removed)

--


This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Note: For the benefit of the community-at-large, all responses to this
message are best directed to the newsgroup/thread from which they
originated.