Work on Document when VBA form is showing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jennie - 28 Dec 2007 14:43 GMT

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

Reply to this Message

David Sisson - 28 Dec 2007 18:19 GMT

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)

Reply to this Message

Jennie - 30 Dec 2007 16:05 GMT

> When you bring up the userform,
>
[quoted text clipped - 4 lines]
>
> (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!

Reply to this Message

David Sisson - 31 Dec 2007 13:16 GMT

> 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.

Reply to this Message

Rate this thread: