Work on Document when VBA form is showing

J

Jennie

I'm very new to VBA but think this should be easy to do....I have a
"QC" form that pops up OnClose of document, it scrolls through the
bookmarks in document asking to user to confirm info. I'd like the
user to be able to click on document and change text if need be, but
the form has control or focus....how can the user click on document
and change while form is present (when they are done, they will click
close on form and it will continue on).
Thanks in advance!
Jennie
 
D

David Sisson

When you bring up the userform,

Userform1.Show False

False sets the ShowModal property to False, allowing editing of
document.

(Doesn't work in Word 97)
 
J

Jennie

When you bring up the userform,

Userform1.Show False

False sets the ShowModal property to False, allowing editing of
document.

(Doesn't work in Word 97)

That works partially but word also pops up the screen "do you want to
save changes" prior to the QC form being acted upon.
Any suggestions for that? Thanks again!
 
D

David Sisson

That works partially but word also pops up the screen "do you want to
save changes" prior to the QC form being acted upon.
Any suggestions for that? Thanks again!

If they change the form, of course it's going to ask to save. You do
want the changes to be saved?

Personally, I wouldn't do this in the close event. I would add a
menubar item that says "Check doc". Let the code check the document,
then manually let the user close the document and save changes.

But then, I really don't understand how your document flows.

Show me the code in the Close event. Or expound on what you're trying
to accomplish.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top